Maybe

=SUMPRODUCT((A2:A7="a")*(C1:F1=3)*(C2:F7))

Mike

"adam&ellie" wrote:

I desperately need help finding a formula that would work on a spreadsheet.
If I had the table below (which is A1:F7) does anyone know a formula that
could give me the figure for items a's volume at week 3? I would also need to
be able to use the same formula to find other numbers using different items,
parameter and week number.

item 1 2 3 4
a price 50 60 20 30
a volume 10 15 12 30
a uplift 18 2 565 12
b price 41 10 350 30
b volume 44 65 49 51
b uplift 85 53 3 4

I dont know if this would help but a possible pointer in the table below
this formula works
=INDEX(B2:E4,MATCH(A2,A2:A4,0),MATCH(D1,B1:E1,0))

1 2 3 4
a 50 60 20 30
b 10 15 12 30
c 18 2 565 12

The only difference I think but can't get my head around is to build in the
price/volume/uplift variable

Please help


--
Adam&ellie