Excell formula puzzle 1

[Shadow1Raider]

Hi
I'm try ing to create a formula tha will return multiple instances of a single unit and add up the quantities, i have seperate sheets 1 for the schedual for architects to set out the ironmongery needed for the project room by room(all iron mungery needed to outfit the room) and the other for the bill of quantity.
this is what i have got so far it returns only the first instance not the others

=if(a11="","",vlookup(a11,ironmongery!A:E,2,false))

any idea how I can tweak my formula to work will be greatly apreciated
thanks

 

[GlennUK]

Look at the SUMIF function.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Shadow1Raider]

Hi GlenUK
thanks tried it keeps giving me that the forula has an error
thanks

 

[GlennUK]

=if(a11="","",SUMIF(ironmongery!A:A,a11,ironmongery!B:B))

... is what your formula should look like.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Shadow1Raider]

Hi GlennUK
thanks after resetting data works like a bomb thanks a million

 

[thegrover]

You might find SUMPRODUCT easier to use for this.