Excel Forum
Similar Content
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...
Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.
Tutorial: How to use a SUMIF or SUMIFS function (or any conditional function or formula) on cell ba...
Count Cells Containing TRUE or FALSE in Excel
Tutorial: Count the number of cells that contain TRUE, FALSE, or one of the two. This lets you count...
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 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF


See three formulas for counting blanks or Not Started (OR criteria):
1. COUNTIF + COUNTIF
2. SUMPRODUCT
3. SUM COUNTIF with array constant criteria

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Cool Formula From Aladin at Mr Excel Message Board





Got a Question? Ask it Here in the Forum.