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

M

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
 
P

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top