Calculate specific values

[Jakes]

Hi there,
Please refer to attached workbook, sheet name floors

The sheet is a list of rooms, with their names, storey and floor area

I want, on sheet name Calculations the totals of each floor areas to display. Note, the sheet "floors" will change as the projects change.

If someone could help me out, I will gladly appreciate it!

Thanks,

Jakes

Fenestration Calculator.xlsm

[Bob Phillips]

You don't give many details, but do you mean

=SUMIF(floors!B:B,"Ground Storey",floors!D:D)

etc.

[Jakes]

Yes indeed. Awesome!

Many thanks!