Try this:
=Sumproduct((A1:A100="N")*(B1:B100="Y")*(C1:C100=" Z"))
You *cannot* use total column references (A:A), and all ranges *must* be of
equal size.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steve" wrote in message
...
Hi,
I'm working with Microsoft Excel 2000 and I am trying to obtain how to
count
the number of rows that correspond to a variety of column criteria (e.g.
column A is equal to "N" and column B is equal to "Y" and column C is
equal
to "Z") but can't seem to work out an easy function to do this.
Can you please help ASAP?
Thanks,
Steve Boscoscuro