MS Excel | CountifS and SumifS Functions

This video covers the countifS and sumifS functions that are used in the spreadsheet software Microsoft Excel. These are used when you want to find the number of or total of something based on multiple criteria.

#MrLongEducation #Excel #Countifs #Sumifs

[CloeDryden]

I am writing my finals tomorrow. And I feel like I won't cry as much as I normally do after a test thanks to these videos. They go by fast so my attention doesn't wonder...Thank you so much!!! 100% life-saver

[Noli.Nyeleti]

I dropped science for CAT in my matric year and use your videos for catch-up thank you so much ✨

[YolandeVanDenBerg]

Hello Mr Long Education. Thank you so much, this was really good. Im writing CAT practical finals tomorrow, and this really helped me alot. I feel really positive about tomorrows test. If it werent for these videos, i probably still wouldnt of understanded by self study!!

[neighthon]

I really struggled with sumifs and countifs now I know I will be acing my CAT test tommorow thanks for the video it really helped.

[ritamatos]

Hi Mr. Long! Thank you so much for all the educational content you provide. I'm learning Excel and I find your way of explaining perfect, in my opinion! I admire that a lot! Best regards, Rita :D

[josefritz]

Mr Long please share this workbook with us CAT teachers. It can be an amazing resource to teach the formulas to our students.

[mohamedmeshref]

More than Excellent explanation.. You are really a very good teacher. But why don't you put an Excel file foe applying the video on it?

[madisonswanevelder]

Thank you sir! Your videos are a lifeline.

[mohammedmatvad]

Hi sir, I am following the method exactly however it is always giving me a 0 answer. I must mention that for some reason the comma, don't work on my excel version or pc. I have to use the semi Colan ; in place of the comma for the command to accept.