Download Excel Files:
Start File: http://excelisfun.net/files/MikeGelGirvinYouTubeExcelMagicTrick11-22.xls
Finished File: http://excelisfun.net/files/MikeGelGirvinYouTubeExcelMagicTrick11-22Finished.xls This is an OLD video. Here is updated video, much better: https://www.youtube.com/watch?v=6c9fIZys7ng
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.
Source
