SUMIF formula in excel | Excel SUMIF Function

[@ExcelSuperstar]

Click here for Excel Basic to Pro Course: bit.ly/34GhsCM

[@abhishekshetty9279]

you have a really good voice yk, you can try dubbing :)

[@Asifkhan-dn5iy]

Indeed you are a superman of excell

[@fawada.matloobjanjua3628]

Agree sir, youre the number one Chartered accountant.,, thanks for being there. ALLAH bless you

[@LearnIndiaLearn]

Fawad Matloob how do u know he is a chartered accountant

[@reprintmind7470]

THNKS NICE EXPLINE AND VOICE

[@shriidharkulkarni6648]

You have a very friendly way of explaining so that even an old and dumb person like me could understand it. My compliments to you.

[@NOSTALGICVlogs]

This has to be the bestestest way of explaining.!!!
Amazingg thankyou soooooo much!

[@rajdevyadav7292]

You're the best Rishabh Sir.

[@anupamaexpress]

इस वीडियो को देखकर मेंरी प्रोबलम सॉल्व हो गयी है। धन्यवाद

[@rajithanaroju5135]

Very easy method...thank you sir...it will useful for me in my daily life

[@asifiqballaleera6649]

Good to See. Very Helpful😍😍

[@nandkishore2993]

Thanks sir for your video . it truly help me.

[@ExcelSuperstar]

Glad to hear that

[@qadeerafridi2336]

thank you sir your teaching method is so fantastic

[@syedfaizan2049]

Behtreen explanation

[@sarithaiva4817]

Thank you so much, really appreciate the quick and understandable explanation 😁

[@ExcelSuperstar]

Glad it helped!

[@newsandentertainment1]

Apki awz bht achi h

[@rahulkumarjha4026]

Thankyou so much sir

[@neelamjhajhria6881]

Very nice thanks

[@80oras]

Ohhhh.....Very nice thank you sir ji

[@tapaswinibarik7191]

Sir, thanks

[@SunilKumar-nv2zp]

Thanks a lot for making this video

[@arifalikhan2005]

Well done

[@sankaryeduru9368]

Thank you bhai
Yaa superbb

[@baniantalkshow476]

Ap 1 vedio bnaow advance exel interview ka bht need ha your method is very easy

[@SujeetKumar-mr1bf]

sir aap ka sam jhane ka tarika bahut achha hai

[@al-ezzacentralac410]

EXCELLENT

[@sureshnagwan7805]

Really liked your video

[@aneelsarwaraneelsarwar194]

Awesome

[@Alaminkhan-nh7ze]

Thank you

[@rakshita2992]

Thank u so much

[@kirtigoplani9744]

Really veryyyyyyyy helpful

[@muhammadumer2011]

Honestly you are a super star teacher of excel, you explains very well simply and clearly of each part

[@dhaneshwardhruw6020]

Very very nice 😊😊

[@PAWANSINGH-pq5bd]

Thank you sir

[@abhaypadhan4666]

Nicely example.

[@ExcelSuperstar]

Thanks! 😃

[@tullex2159]

i dont understand why these indian youtubers write the title in english but the guy explains in indian language

[@javedburney4825]

Nice way of teaching. keep it up.

[@aakashlko92]

Bhai aapki voice quality bhot acchi Hai

[@shaheeribethaj5229]

Thanks Alot sir

[@mohammedabdulaziz7480]

Excellent dear

[@qudratullah4372]

Thank you Sir
Sir make a video about vlookup and hlookup function

[@funwithjazil4408]

Good information

[@ABHISHEKKUMAR-ze7ix]

Very nice video

[@dsolanki1499]

Thanks a lot sir . I have tried for two or three times then I got and did it.

[@ExcelSuperstar]

Well done

[@syedamirulislam4092]

Thank you Brother❤

[@diptojitsadhukhan]

Thanks

[@user-dj5qh1ut4t]

thanks it was helpful.

[@saddamhussain2144]

Nice sir 👍🏻👍🏻

[@ExcelSuperstar]

Keep watching

[@iqramanzoor1224]

Thankyou

[@abhijitmane2570]

thanks Bhai

[@rahul1726]

Thnx🙏

[@ExcelSuperstar]

Welcome 😊

[@Another_possibility]

Excellent speaking skills, super boy

[@shubhamjoshi6667]

YOU GOT NEW SUBSCRIBER, KUDOS

[@zeeshanmurtaza8940]

Sir please prepare videos based on Account Reconciliation by using advance excel tools. Example : Matching cash book with bank statements. Thanks

[@muhiburrehman7232]

Thanks Sir.

[@ExcelSuperstar]

Most welcome

[@harshalgarje8146]

Good teaching sir

[@ExcelSuperstar]

Thanks and welcome

[@dharmendrayadav-bw2gp]

Nice explain sir. Please explain sumifs

[@TECHNOLOFT0]

Thankyou bro😭😭😭

[@caaman93]

Your voice 🔥

[@imnithinpaul05]

I frickin love you dude ❤️💙

[@siddheshsawant5452]

why we freeze range? please answer....

[@srinivasuluhrd]

Good sir

[@MuhammadAli-gk8rx]

Thanks boss

[@piytube1]

We can easily create sumif formula with the help of excel vba
Sub sumif()
Range("b9").Value = Application.WorksheetFunction.sumif(Range("a2:a8"), 1680, Range("b2:b8"))
End Sub
#excel #vba #excelvba #microsoftexcel #microsoftoffice #data #sum #sumif #vbamacro #vbacode #excelformula

[@pritisinghart1160]

Thanks 😊

[@ExcelSuperstar]

Welcome 😊

[@rohitlalwani7993]

Best

[@priyambadasah]

thnkx so much sir..

[@ExcelSuperstar]

Most welcome

[@devendrarawat7123]

thanku sir

[@sanketaherpatil]

thanks , it truly help me !

[@alfabuntygaming6910]

🙏

[@GAUTAMJAINBME]

upon different selection of cells, why it shows 5 instead of 4. Why 5 and not 6, 7, 8 or any error.

[@naseerahmad6422]

Please confirm me why use f4 to fix both thing

[@archanaaa2514]

Sir, how to solve excel errors? Please upload video on solving all kind of excel errors

[@rahulwagadiya5126]

Nice 👍

[@ExcelSuperstar]

Thanks ✌

[@archanabramhankar]

very useful and nice video

[@mangalkatakdhond6381]

Archana Bramhankar gffftt5tt oo

[@Kabhylamee]

wah MAST

[@quickexcel2412]

Good 👍👍

[@ExcelSuperstar]

Thanks

[@nonucool1820]

Sir nice video

[@dharmendrayadav-bw2gp]

Sir one more requests if possible please publish a video regarding ms access deta relationship how to do it. If you have published then please share link.

[@sujeetvishwakarma1817]

Dear Sir,
Can you please explain me when I have data from numbers 1 to 100 but I want answers from between 50 to 100 with using sumifs formula
How can I show it in criteria

[@b0red7]

can you make a tutorial on taskade next?

[@kukkalarajesh3041]

How it was reading E3 i want to know that , how the F3 know that it must read from e3

[@foodiedasbrothers7185]

nice video sir

[@AmanKumar-un4lb]

Sir agar ham par criteria limited hai lekin sum and sumrange entry type mai hai usme daily entry hoti hai to sir uske liye kya kare please reply sir stock entry and consumption ke liye excel bana raha hu usme jarurat hai sir please reply anyone know

[@rizwanulhaque1926]

Good

[@rezwanbabakarkhil2436]

sir by this formula just we can calculate tow items cauz i did 3 item the 3rd one was zero

[@sumona3072]

plz share about macro

[@BakwasBlog]

What if we need total OR Average of caps/Bikes in three different months, e.g. CAPS IN JAN, FEB, MAR (8+11+3) ?

[@gopinathgajendran2991]

use sum(offset(jan,feb,mar)

[@dr.atultiwari4954]

I am facing a strange problem. In Sum & Large (Nested) formula,
Here is the process I did-
I typed some figures (5,7,3,9,0,0) in cell row (C5 to C11).
Now I used "IF" formula in cell row C15 to C20 instructing that if Cells C5 to C11 Contains a number that is more than 1 then put ".5" in cells C15 to C20 else display 0.
It worked well & I got desired number (.5) in desired row (C15 to C20).
Now problem began
In Cell C21, I put SUM +LARGE formula together instructing to display "SUM of top 4 numbers from selected cell rows C15 to C20". They all carry same number / figure (.5).
But it shows a "Number_Error"?
I thought that formula (SUM+LARGE) is not recognizing digits contained in C15 to C20 (.5) as number because there were not typed there but appeared through "If" formula.
To confirm that I used only "SUM" formula by selecting cells (C15 to C20). I thought when formula (SUM + Large) is not recognizing ".5" contained in row (C15 to C20) as number then "Sum Function" will also not recognize it as a number & will not give me total of it (C15 to C20).
But I was stunned when SUM formula gave me the correct result!
That means- digits of (.5) are well recognized correctly by formula but nested formula (SUME + LARGE) is showing "Number_Error". I have given up so seeking you for help.
Another probability is- nested formula (SUM + LARGE) doesn't work for a row? but only for column or whole array? I don't know.
Being expert in field only you can deal with this.
Please help & Oblige
Thanks
Dr. Atul Tiwari (MD)

[@ir9ir9]

Sirji, what is the formula for the Color font in a range in countif for ex: COUNTIF(L8:L23,"Green" but I am getting, range is L8:L28 I need green colored font

[@AnkitPATEL-ql6ix]

what if you want a total of both CAPS and BIKES? how to do that? thanks in advance sir

[@coolmovies4561]

Sit VBA ke bare me ek video daliye please

[@KC_47.]

How to use countifs fucntion which has multiple criteria ny using {}?

[@KC_47.]

@@learningmagnet6252 thanks a lot sir.. I'm keen to learn.. 😂

[@KC_47.]

@@learningmagnet6252 I'm sorry sir.. But that video not answer for my question.. My question is, countifs MULTIPLE criteria.. multiple in multiple..

[@abhaykulkarni8015]

Hi Rishabh is there any CD package available for your videos?

[@ExcelSuperstar]

Pendrive Package available on www.excelsuperstar.org/excel-course-hindi-english-mix/
50% Discount on Full Advanced Excel Course

[@aayushjindal6179]

Should improve on explanation and focus more on the core of the formula, rather than what to select

[@shivaysrivastava8209]

And formula btaye

[@azhadshamim3122]

Sir,
Plz kindly make a video for Extract report " From Date :
End Date :
I followed some video but report Extracting with unwanted Date

[@nonucool1820]

or video bnaye plz send kre new formule k sath

[@kavitaborase3479]

Sir, excel me hum fraction kaise use krskte hai ?

[@allisone3835]

Aap jo yha per fo jo lagta hai to kase legate hai plz