The Excel SUMIFS Function

You cant use SUMIFS to get cost of blueray and DVDs? So the criteria range is on both

Well done!! Thank you for sharing!

Thank You

i dont understand the sumifs

Thank you so much I struggled with understanding this, this video made me understand the formula!

Sir I have payments received from the customer side but the diff payment will show in excel what is formula?????

I see mystery in three cells, which would add to more than the amount you posted.

Can you use pivot too?

I wish as you're explaining things you would leave it on the cell you just created the formula in so we could examine it closer because you're too fast for teaching

Hi😊

Hi😊

I just subscribed. Could you please review the link you posted to download the Excel file for us to practice with? That link does not work to download the file, but to take us to the tutorial video instead. I have tried those links to download other files and they don''t work either, they take us to the same video tutorial, not to download the actual file to practice. Thanks!!

Simple and to the point. Love it!

Super Helpfull!

Before I watch this video, I was struggling with sumifs function. However after I watch it, it was so clear explanation. I really like this video.

Very clear and straightforward explanation, thank you !

P pooja pooja

The last formula missed the Mystery Dvd at the top for $19.00?? 19 + 15 + 9 is what it should have grabbed.

Nice explanation. Thank You.

I am trying to make an Automatic Bowling Scoresheet. Any suggestions for the formula here?

Great Video….

I have to add to all the praise here - I am also creating a budget and have been getting my brain tangled up in knots watching Excel videos... you are the first person to actually make this easy and accessible. THANK YOU!!

Sir, SUMIF not working when referencing a cell with a formula, any solution?

Geat job !! easy to follow. I am now a subscriber.

This is the first viideo I watched to learn SUMIFS formula and I understood very well. Thanks for your video and I have subscribed.

Hello Sir,
A B C
1.20 40 30
2.(10) 50 [60
3. 20 30 20
4. 50 10 10
5. 60 10 80
6. 30 (90) 50]
7. 20 20 70
In above eg. A2 has minimum value & B6 has maximum value, so from this range
2-6 I want sum of column C2-C6 (60+20+10+80+50).
so from the 1st column minimum value cell to 2nd column maximum value cell, I want sum of in-between cells of column C.
I have 1000s sets each set of 7 of 3rows with 3 columns to execute in this manner.
I m providing one more eg. so that u have better understanding.
A B C
1. 50 30 30
2. 60 20 40
3. (30) 10 [50
4. 90 80 60
5. 70 (90) 30]
6. 50 70 20
7. 40 40 10
from min value of column A3(30) to max value B5(90), sum all cells of column C, C3 to C5 that is [50+60+30].
Please help with this question.
Thank You.

THANK U

Ghg

Thanks. you made my day!

great basic

THANKYOU YOU MADE MY LIFEEASY.HELPED ME TO COMPLETE MY PROJECT THANKS A LOTTT!!!!

thanks for explanation.

Can you use 2 selections from the same criteria range? e.g. if you want the cost of mystery and horror in the same sum, cheers.

So, it's basically a handy form of the AND function in excel for summing?

Reeeeeaaally great video thank you

This video saved me today! Thank you thank you

Thank you so much 🙏

Thank you!

Thank you ! helpfull

This video was very helpful. Thank you very much.

Can the first and second criteria range be the same range

Thank you Sir ! It really is helpful .

Thank you ❤

Where is the data that he uses?

Awesome! Love excel!

Thanks.

very clear tutorial

i like how you explain small tips and tricks along the way.

how did you make those title cells with the drop menu ex. "formula, genre" ?