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 * * * * * * * * * * * * * * * * * * *