=SUMPRODUCT(--(A1:A100=""),--(B1:B100=0),--(C1:C100=0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"jb" wrote in message
...
Hello,
Following up on previous help provided and which as worked great:

Without having to add a column to a spreadsheet, I need to count the
number
of rows that match criteria based on three columns. That is, If column A
is
blank AND column B=0 AND column C=0, this would count as 1 valid row,
otherwise 0 valid row. It looks like I could do this somehow with IF()
and
I'd like to use one of the functions you guys have been referencing
(sumIF,
countIF, etc.). I do not know how to use compound criteria. I thought I
could do something like =Sum(IF(A="" AND B=0 AND C=0, 1, 0)), but that
doesn't
seem to work. I see there is an AND function: AND(A="",B=0,C=0) or
something like
that. I know I could use a DCount() function, but I was hoping to avoid
using
criteria columns in my spreadsheet. Very confused.

Thanks for any help!

John