Hello everyone,



I'm making an inventory file. This file has a sheet with types of furniture T0001, T0002 and so on are the different types.
And there is a sheet with unique codes that are assigned to each furniture piece, codes are ABC00001 and so on.
In the CODES sheet '1' is placed in the room where the furniture piece is.
I'm looking for a formula to paste in each cell in the TYPE sheet.
So I have a sum of how many of a specific type of furniture is that room.

I tried a SUM combined with VLOOKUP but didn't work.
Who can help me?
Example file in Example inventory.xlsx

Have in mind in the actual file there are much more codes, rooms en types so one formula to copy trough the rows and coloms would be super!

Sheet CODES.jpg
Sheet TYPES.jpg

Many thanks!