Excel Forum
Similar Content
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Remove Gridlines from Only Part of a Worksheet in Excel
Tutorial: How to remove gridlines from a part of a worksheet in Excel instead of the entire workshe...

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.