Excel Forum



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.