View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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...?