To view the Total Cost per Room in Spreadsheet View, click the drop-down menu for the Area column and select which Area or Room you'd like to see.
Select all items in that Area by clicking Select All Items circled in red or by clicking the select all box.
The Total Cost Per Room will show in green font for the Area selected.
