Function to consolidate totals

I'm looking fo a function that allows me to consolidate the same type of information from different tables. For example, my sheet has three different properties (i.e. house, cabin, townhouse). Each has stairs. I want those stairs to total on line 3. ThanksConsolidating information.xlsx

use

Formula:

Please Login or Register  to view this content.

in the C3 cell and copy it to all the yellow range

Put this formula in C3:

=SUMIF($B$10:$B$22,$B3,C$10:C$22)

then copy across and down the rest of your yellow area.

Hope this helps.

Pete