Sum if formula

[KevinThomas]

Hi All, I need to incorporate a sum if formula twice in one string (I think).

I have attached a document.

I column a I have the "Part"
In Row 1 I have the month (as a number).

If I want to return the value of item 040k for November (11) how could I do this to give the sum - 11,430?

[NBVC]

Try:

=SUMPRODUCT(($A$2:$A$9=B13)*($B$1:$AF$1=B14),$B$2:$AF$9)

where B13 contains 040k and B14 contains 11.

adjust as necessary.

[KevinThomas]

Thats great - thankyou