View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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