View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default SumProduct Solution?

=SUMIF($B$1:$AZ$1,"A",$B2:$AZ2)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sige" wrote in message
oups.com...
Hi There,

A B A B B A A B A ....
A4251
A4231
A4261 Data numbers
A4272
A4278
AUnique
...

I would like to sum all data for which criteria in first row = A
&
Code in first column equals eg A4261

Explained differently: summing all data which is on line A4261,
condition that there is an A in the first row.

Any help really appreciated,
Sige