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

Download Excel Files:
Start File:
Finished File:
Full Page With All File Links:

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.

Microsoft,Excel,spreadsheets,SUMIF,COUNTIF,sum,add,count,conditionally,given,criteria,mike,gel,Girvin,highline,community,