Countings rows based on column criteria

S

Steve

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
[email protected]
 
M

Mike

Try this,

=SUMPRODUCT(--(A2:A10="N"),--(B2:B10="Y"),--(C2:C10="Z"))

I have assumed your data are in A2 to C10, allter to suit.

Mike
 
R

Ragdyer

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.
 
Top