aqualiscious Posted October 3, 2011 Share Posted October 3, 2011 (edited) Hello, I am trying to use the SUM comment icon in a door/window schedule to summarize the total number of doors/windows of each particular size. I can get this part to work easily enough. The problem I have is to do with the SUM (summary) command multiplies all the individual door/window attributes by my count. In other words, instead of displaying 10 doors at 3'0x7'0 each, the spreadsheet displays 10 doors totalling 30'x70'... Please see attached screen capture. Any ideas? I've tried altering the formula in the door.width cell, dividing it by the cell containing the count but the result is some strange number, much smaller than it should be... ?? Edited October 3, 2011 by aqualiscious Quote Link to comment
willofmaine Posted October 4, 2011 Share Posted October 4, 2011 Try adding a SUM icon to both your Width and Height columns, as well as to the door sizes column. I think this will resolve your issue. Doing this is probably very logical mathematically (I've yet to work through it...), but intuitive it is not. Unfortunately, you can only use the SUM icon for three columns (unless you're using VW 2012, in which case I think this may be unlimited) so a lot of your other columns, such as door thickness and jamb depth, will remain problematic.... HTH Quote Link to comment
aqualiscious Posted October 4, 2011 Author Share Posted October 4, 2011 Thank you willofmaine. That did the trick... Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.