Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF
Loading...
Loading...
1,447
Link to this comment:
Share to:
Loading...
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun568 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,314 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 3:52"countif" formula in excel 2007by questpondexcel826 views
- 7:17Excel Formula Efficiency 4: SUMIFS & COUNTIFS A...by ExcelIsFun26,985 views
- 3:01Excel Magic Trick 694: SUMIF Can't Handle Array...by ExcelIsFun1,929 views
- 11:36Excel Magic Trick 683: 3 AND criteria & 3rd AND...by ExcelIsFun2,511 views
- 3:58Nesting IF and AND functions in Excel 2007by sharonlibrarian11,806 views
- 9:12Excel Magic Trick 777.5: SUMPRODUCT Function OR...by ExcelIsFun2,639 views
- 5:59Use the Countif () Function to find out how man...by DannyRocksExcels1,528 views
- 4:28IF ERROR - A Cool new Excel 2007 Functionby cpaselfstudy6,838 views
- 5:57Excel Magic Trick 707: RANK with Criteria - SUM...by ExcelIsFun1,996 views
- 5:00Excel Magic Trick 728: COUNTIF & AND Functions ...by ExcelIsFun1,570 views
- 6:08Excel Magic Trick 678: SUM only Values After De...by ExcelIsFun1,090 views
- 36:28Excel Magic Trick 777: SUMPRODUCT Function -- B...by ExcelIsFun5,483 views
- 5:46SUM SUMIF COUNT COUNTIF - Excel for Business - ...by raycolondotcom59,169 views
- 10:52Excel Magic Trick 497: Unit Inventory Total For...by ExcelIsFun17,403 views
- 8:12Excel Magic Trick 714: Three Criteria Lookup Ad...by ExcelIsFun5,541 views
- 9:52Microsoft Excel Tutorial - If Then Formula Equa...by mouseflip3,034 views
Me too!
Technically it is not an array formula because it does not use Ctrl + Shift + Enter. The last formula contains an "array constant" but it does not require Ctrl + Shift + Enter.
However, one problem with the last one is that you are hard coding the criteria into the formula. If you don't want to do that, I like the first one COUNTIF + COUNTIF. That is why I teach the COUNTIF + COUNTIF.
ExcelIsFun 1 year ago
I think I like the last array formula. Quick and easy. Thanks Mike.
krn14242 1 year ago