SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3

November 2010 Update: Visit: http://www.ExcelinaMinute.com/ for my new Excel video tutorials. "One minute videos for bite-sized learning!"

Excel tutorial on the uses of the math functions SUM, SUMIF, COUNT, and COUNTIF.

Category:

Education

Tags:

• Excel
• business
• math
• functions
• SUM
• SUMIF
• COUNT
• COUNTIF
• computer
• science
• spreadsheets

[jimaster93]

Thank you for sharing your knowledge with us!

[raycolondotcom]

@jimaster93 You're welcome. Glad you found it helpful.

[cesterx]

Jako dobro, kratko i korisno. Bravo!!!

[raycolondotcom]

@cesterx Hvala Vam. Drago mi je pomoći. (via Google Translate) :)

[PHILZ82]

the guy who is givin the voice sounds like an italian mob boss!!!!!! no offence loved it

[raycolondotcom]

@PHILZ82 LOL, thanks for the laugh, PhilZ. Now I'll have to make you an offer you can't refuse. :) Ray

[JocaBrate94]

thanks so much dude

[jonathan92591]

Such a great lesson! Thank you!

[regal033]

Brilliant!! I was looking for how to do a "countif" statement. You explained it very well. Thanks!

[VideoGameRoom32]

Great video. What if I have a range from L3 to L26 has sum and the total amount should be on L28. IF L3 to L10 have an amount but L11 to L26 says "N/A" How do I get it to add up the numbers and ignore the N/A to get the total amount in L28. Thanks. Because right now L28 is not adding up the total amount if there are N/A the L cells.

[MsNJohnson]

another great video!!!!

[shikha0085]

good