View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ela ela is offline
external usenet poster
 
Posts: 16
Default counting by group


"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...?