| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 excelisfun | 2008-03-05 15:50:25 |  1,096,082 Views |
Download Excel Files:
Start File: https://excelisfun.net/files/MikeGelGirvinYouTubeExcelMagicTrick11-22.xls
Finished File: https://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.
Start File: https://excelisfun.net/files/MikeGelGirvinYouTubeExcelMagicTrick11-22.xls
Finished File: https://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.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
