Excel Forum



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





Got a Question? Ask it Here in the Forum.