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 :)

[@siddheshsawant5452]

why we freeze range? please answer....

[@GAUTAMJAINBME]

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

[@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

[@tullex2159]

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

[@NOSTALGICVlogs]

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

[@baniantalkshow476]

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

[@qudratullah4372]

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

[@naseerahmad6422]

Please confirm me why use f4 to fix both thing

[@aayushjindal6179]

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

[@kukkalarajesh3041]

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

[@rajithanaroju5135]

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

[@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

[@sarithaiva4817]

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

[@ExcelSuperstar]

Glad it helped!

[@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

[@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

[@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

[@80oras]

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

[@reprintmind7470]

THNKS NICE EXPLINE AND VOICE

[@anupamaexpress]

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

[@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.

[@neelamjhajhria6881]

Very nice thanks

[@arifalikhan2005]

Well done

[@sankaryeduru9368]

Thank you bhai Yaa superbb

[@qadeerafridi2336]

thank you sir your teaching method is so fantastic

[@zeeshanmurtaza8940]

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

[@rahulkumarjha4026]

Thankyou so much sir

[@tapaswinibarik7191]

Sir, thanks

[@aneelsarwaraneelsarwar194]

Awesome

[@nandkishore2993]

Thanks sir for your video . it truly help me.

[@ExcelSuperstar]

Glad to hear that

[@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)

[@alfabuntygaming6910]

🙏

[@rakshita2992]

Thank u so much

[@SunilKumar-nv2zp]

Thanks a lot for making this video

[@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)

[@aakashlko92]

Bhai aapki voice quality bhot acchi Hai

[@al-ezzacentralac410]

EXCELLENT

[@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..

[@shubhamjoshi6667]

YOU GOT NEW SUBSCRIBER, KUDOS

[@rajdevyadav7292]

You're the best Rishabh Sir.

[@newsandentertainment1]

Apki awz bht achi h

[@archanaaa2514]

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

[@Alaminkhan-nh7ze]

Thank you

[@rezwanbabakarkhil2436]

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

[@syedfaizan2049]

Behtreen explanation

[@shivaysrivastava8209]

And formula btaye

[@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.

[@azhadshamim3122]

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

[@kirtigoplani9744]

Really veryyyyyyyy helpful

[@akshitagupta4127]

I cannot get the $ sign. Pressed F4 key but it isn't working. Tried doing so by pointing the cursor in the cell as well, not happening.

[@ExcelSuperstar]

Use Fn + F4 key

[@PAWANSINGH-pq5bd]

Thank you sir

[@AnkitPATEL-ql6ix]

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

[@Another_possibility]

Excellent speaking skills, super boy

[@saddamhussain2144]

Nice sir 👍🏻👍🏻

[@ExcelSuperstar]

Keep watching

[@abhaypadhan4666]

Nicely example.

[@ExcelSuperstar]

Thanks! 😃

[@parekhnisha1236]

Thank you sir

[@ExcelSuperstar]

Welcome

[@alamshah7303]

Simple si chiz ko itna complicated kyu bana rahe bhai ki banda bore ho jaye...ghuma phira ke bate logo ko samjh nahi ati ap apna comment box delhiye aur video bhi dekhiye ki jis tarah se apne explain kiya hai...was that needed?? plz don't mind my intention was not to offend you but to tell you that don't make things complicated unnecessarily.

[@b0red7]

can you make a tutorial on taskade next?

[@سبرنگ-و5د]

thanks it was helpful.

[@arijeetkumarsharma226]

Awesome

[@shaheeribethaj5229]

Thanks Alot sir

[@dharmendrayadav-bw2gp]

Nice explain sir. Please explain sumifs

[@asifiqballaleera6649]

Good to See. Very Helpful😍😍

[@javedburney4825]

Nice way of teaching. keep it up.

[@arslanyousaf3722]

Yeh kam nahi kr raha mery pas 2000 rows tak ka data hai pr kam nhi kiya

[@SujeetKumar-mr1bf]

sir aap ka sam jhane ka tarika bahut achha hai

[@allisone3835]

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

[@rahul1726]

Thnx🙏

[@ExcelSuperstar]

Welcome 😊

[@imnithinpaul05]

I frickin love you dude ❤️💙

[@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

[@TECHNOLOFT0]

Thankyou bro😭😭😭

[@sureshnagwan7805]

Really liked your video

[@chotelalpandit4771]

Mujhe item sum krna hai to kaise kre

[@syedamirulislam4092]

Thank you Brother❤

[@damodarbangalore7003]

Thanks a lot sir

[@yshakn4530]

Sir are you a dub artist?

[@ExcelSuperstar]

Nope

[@yshakn4530]

@@ExcelSuperstar I have heard this voice somewhere before🤔

[@shivangi2012]

Why do you try to act oversmart?

[@Pradeepbhardwaj193]

1548678 4563158 9645317 4658863 Inme se agar koi ek no nikalna ho to Kya formula use hoga Jaise mjhe 8 alag Karna Hai isme se please tell me

[@kavitaborase3479]

Sir, excel me hum fraction kaise use krskte hai ?

[@dhaneshwardhruw6020]

Very very nice 😊😊

[@caaman93]

Your voice 🔥

[@funwithjazil4408]

Good information

[@devendrarawat7123]

thanku sir

[@MuhammadAli-gk8rx]

Thanks boss

[@mohammedabdulaziz7480]

Excellent dear

[@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

[@abhijitmane2570]

thanks Bhai

[@iqramanzoor1224]

Thankyou

[@finance9how215]

hi rishab

[@srinivasuluhrd]

Good sir

[@diptojitsadhukhan]

Thanks

[@rohitlalwani7993]

Best

[@knowwisdom3348]

Why we are freezing cells by using F4

[@SyedUsman]

To lock the range so that it doesn't change when u copy the formula.

[@harshalgarje8146]

Good teaching sir

[@ExcelSuperstar]

Thanks and welcome

[@Ghazala_Aizal]

F4 press krne se $ aye ga us se kia faida hoga??

[@qadirization]

Kya hum sabhi items ka sumif ek bar m Karen sakte hai?

[@priyambadasah]

thnkx so much sir..

[@ExcelSuperstar]

Most welcome

[@santoshkumarbhatt]

maine jo query di thi uska hal nahi duya apne