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 bac...
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 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.