How To: Count with OR criteria in Microsoft Excel 2010

Count with OR criteria in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:

1. COUNTIF + COUNTIF
2. SUMPRODUCT
3. SUM COUNTIF with array constant criteria

Daily Tips For Your Phone

Get the Gadget Hacks newsletter for new tips every day.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest