counting by group
No, it is not an array formula, just a standard formula.
Pn is column P, down to some indeterminate row, n, that only you know.
$L2 is the decision value being tested, FN in row 2, FOP in row 3, etc.
--
__________________________________
HTH
Bob
"ela" wrote in message
...
"Bob Phillips" wrote in message
...
Assuming the results table is in L1:Pn, in M2 enter
=SUMIF($A:$A,$L2,C:C)
and copy across and down.
--
__________________________________
HTH
Bob
it seems you are using array formula...?
What's Pn?
and $L2 are the condition criteria, what are they...?
|