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