SumProduct Solution?
If your data is in Cells A1:G10, try this:
=SUMPRODUCT((A2:A10="A4261")*(B1:G1="A")*B2:G10)
Adjust the range references to suit your situation.
Does that help?
***********
Regards,
Ron
"Sige" wrote:
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
|