Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

Loading...

Sign in or sign up now!
46,797
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 5, 2008

See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina -- or count them! Also, see the super fast keyboard shortcut for naming multiple ranges.

Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • THANKS A EFFING MIL, Been struggling whole day at work to be able to do this and its so simple...

  • @coke491 , I am glad that the vid helped!

  • dude you are brill you have given me a anwser to a formula that i have been wanting for weeks

  • EXCELlent!!

see all

All Comments (33)

Sign In or Sign Up now to post a comment!
  • NO WAY!!!!! hahahahahahahahhaha.... ;)

  • Funny tone of explaining...its like you're talking to a baby!!! :D anyway, NICE ONE!!! ;)

  • video is great but that voice makes it hard to watch

  • @sareze1 , I do not know how to download video, but the Excel file can be downloaded here:

    people.highline.edu/mgirvin/Ex­celIsFun.htm

  • @ExcelIsFun .. how do I go about down loading the file/video. thanks

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more