Excel Magic Trick 854: COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column

[0selam]

great! I wonder if you could kindly answer my question?

Can I use if and SUM same way ?

I'm working on an overview page for date spread over many sheets.

[ExcelIsFun]

@0selam , yes you could use SUMIF function. see this video:

Excel Magic Trick #203: SUMIF function formula 21 Examples

or

Highline Excel Class 09: SUMIF Function Formula 3 Examples

[0selam]

@ExcelIsFun Thanks a lot! much Appreciated!

[ExcelIsFun]

@0selam , you are welcome!

[ExcelIsFun]

krn14242, this was answering a question. But yes, the demand for Basic Videos is always very high! Higher than for advanced videos!

[krn14242]

Thanks Mike. Reverting back to basics? :)

[ExcelIsFun]

Cosme422 , I am glad that it worked and solved your problem!

[Cosme422]

Thank you, thank you, and thank you again!!! 

[ExcelIsFun]

urpanita , I am glad that you liked it!

[ExcelIsFun]

sperdoch, you are welcome!

[sperdoch]

Another great tutorial.

[ExcelIsFun]

sawan202, The Duels have been put on hold for the last few weeks because Mr Excel had a bunch of important business! They will start back up Next Friday, Jan 20!!

I can't wait!!

[sawan202]

Thanks but it's friday what happened to the duelling with Mr Excel??? :-)

[urpanita]

Great function!!!! thanks for upload ^^