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