How do I count the number of entries of specifc criteria is met

[Mark_h]

Hi,
I'm trying to count the value in one column but only if the criteria in an
ajoining column is met. There are loads of columns and rows but 2 columns
contain the following:-

Column K contains values of 0%, 25%, 75% and 100%
Column M contains values of 1, 2 or 3.

I would like to count the amount of 1's that are at 25% ar 50% and 75% and
100%. I would then like to do the same for the 2's and 3's...
Each result will be displayed in a different cell.

E.G.
Priority 0% 25% 50% 75% 100%
1
2
3

 

[Pete_UK]

Assuming your summary table is in A1:F4, put this in B2:

=SUMPRODUCT(($K$2:$K$100=B$1)*($M$2:$M$100=$A2))

Adjust the cell references and ranges to suit your data, then copy
across and down to fill your table.

Hope this helps.

Pete

 

[Ashish Mathur]

Hi,

You may also use a pivot table. Drag column M to the row area. column K to
the column area and column M to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com