Countings rows based on column criteria
 

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

Countings rows based on column criteria
 

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

"Steve" wrote:

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

Countings rows based on column criteria
 

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