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 ba...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.