Main Profile

At A Glance

Excel Magic Trick 457: SUMPRODUCT & OR Criteria

See how to count all the Fridays and Mondays in a list of dates using the SUMPRODUCT function and the OR criteria plus symbol +. See the TEXT and WEEKDAY functions. Learn how the COUNTIF function will not work because COUNTIF does not handle arrays
Length: 05:27

Contact

Questions about Excel Magic Trick 457: SUMPRODUCT & OR Criteria

Want more info about Excel Magic Trick 457: SUMPRODUCT & OR Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question