Excel Forum



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


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.





Got a Question? Ask it Here in the Forum.