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...
Add Check Marks to Cells by Double-Clicking or Typing
Tutorial: Input a check mark into a cell in Excel by double-clicking the cell or by typing a letter...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.