|
Featured Tutorial
Featured Macro
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
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