=SUMPRODUCT((A2:A100="A")*(B2:B100=1)*isnumber(c2: c100))



Zoltan wrote:

Is it possible to expand this further by only returning a count if a number
is present in a third column. This number does not have to be anything
specific it is just nessasary that a number be entered in the third column.

eg: D2: =SUMPRODUCT((A2:A100="A")*(B2:B100=1)*(C2:C100=ANY NUMBER?))

Thanks again for all your help.

"Max" wrote:

If you're using numbers as the criteria, just drop the double quotes, eg:

In C2: =SUMPRODUCT((A2:A100="A")*(B2:B100=1))

The double quotes is necessary for text.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zoltan" wrote:
Thanks!!!

I got it to work with "YES" but it doesn't work if I use "1"s and "0"s. Is
there any way to make it work with numbers?

Sorry about the new thread I posted, I'm new to this.

Cheers!

--

Dave Peterson