minotto 6 Posted May 23, 2017 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 Quote Share this post Link to post
PVA - Jim 2,383 Posted May 23, 2017 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. Quote Share this post Link to post
minotto 6 Posted May 23, 2017 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? Quote Share this post Link to post
PVA - Jim 2,383 Posted May 23, 2017 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. Quote Share this post Link to post
Marissa Farrell 461 Posted May 23, 2017 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. Quote Share this post Link to post
minotto 6 Posted May 23, 2017 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. Quote Share this post Link to post
PVA - Jim 2,383 Posted May 24, 2017 12 hours ago, minotto said: i think the worksheet/ schedule capabilities need a revision - simplified We agree! This is planned. 1 Quote Share this post Link to post