Excel Forum
Similar Content
Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.
Tutorial: How to use a SUMIF or SUMIFS function (or any conditional function or formula) on cell bac...
Allow Only Certain People to Edit Specific Cells in Excel
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...

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.