View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
blswes blswes is offline
external usenet poster
 
Posts: 13
Default countif with multiple criteria

Great. Thank you for the SUMPRODUCT solution.

As a follow-up question, if there are 25 entries that have values greater
than 0 across my three different columns (A,B,C), how would I add up the
values from an additional column (D) for only the entries that met my
original criteria?

Thanks,
Ben

"Max" wrote:

Something like this, in say D2:
=sumproduct((a2:a1000)*(b2:b1000)*(c2:c1000))
Adapt the ranges to suit. All ranges must be identical size.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"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