Roof Components in a Worksheet - Total Thickness

[minotto 5]

I've attached a file that i'm using to learn worksheets.  I'd like to add up the cells that contain the thickness of the roof component and show the total thickness in a separate cell.  I've tried using the SUM function as suggested by JimW in another post but i'm doing something wrong.

 

Any help is greatly appreciated.

 

 

Worksheets.vwx

[Jim Wilson 2,187]

View > Show Database Headers is currently On. I suspect that for this worksheet you just need to turn them off to display each component's thickness just once.

[minotto 5]

Yes but the total Roof Thickness in cell C3 which adds up cells of the components, C6 to C10 is not showing up.

How would i fix this?

[Jim Wilson 2,187]

I've not seen one configured with this many database header rows before, but I am not an expert with worksheets. However in a separate new row set to Spreadsheet rather than Database, =C6+C7+C8+C9+C10 summed them up without issue. I do not know why it isn't letting that happen in the C3 as you set it up here.

[Marissa Farrell 335]

I would use "width" instead of summing the cells, since you're querying the same roof style throughout.

 

It would get trickier once you start introducing other styles, though.

[minotto 5]

Thanks for all your suggestions.  

 

Like the Resource Browser which was redesigned recently and is a lot more intuitive and efficient than it's prior incarnation , i think the worksheet/ schedule capabilities need a revision - simplified with BIM in mind where the whole process of extracting information from a model requires less effort.

[Jim Wilson 2,187]

12 hours ago, minotto said:

i think the worksheet/ schedule capabilities need a revision - simplified

We agree! This is planned.