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
|