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

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

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

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

On Aug 18, 10:44*am, Mark_h wrote:
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 * * * * * * * * * * * * * * * * * * *

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

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

"Mark_h" wrote in message
...
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