View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Andrea Jones Andrea Jones is offline
external usenet poster
 
Posts: 63
Default countif with multiple criteria

Are you wanting to count how many rows there are where all 3 numbers on the
row are greater than 0? If that's the case you can use a SUMPRODUCT function
like

=SUMPRODUCT((A2:A100)*(B2:B100)*(C2:C100))

Andrea Jones
www.stratatraining.co.uk

"blswes" wrote:

How do I count entries that meet multiple criteria across multiple columns of
data?

Specifically, I want to count how many entries have a value greater than 0
in all three different data columns that I'm ranging.

I feel like it's some combination of COUNTIF and AND that's beyond me.

Thanks,
Ben