Main Profile

At A Glance

Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1. See how to avoid using SUMPRODUCT and TEXT function when using "Jan" Month Criteria by using SUMIFS and the number one "1" Joined (Ampersand) to the "Jan" criteria.2. Great Trick to speed up the calculating of the formula.3. Two Criteria (Condition) adding and counting with SUMIFS function.Category: SUMIF, COUNTIF, COUNTIFS, SUMIFS, Count or Add with more than one criteria, Weekly Reports, Charts.
Length: 08:58

Contact

Questions about Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria

Want more info about Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question