Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code help, delete rows based on column criteria | Excel Discussion (Misc queries) | |||
Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Copying whole rows based upon one criteria | Excel Discussion (Misc queries) |