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