VW-PAD-Bristol-2014 Posted October 14, 2014 Share Posted October 14, 2014 Hi All, I have a symbol with a record attached, one of these record fields is sqft as a number value (to allow me to calculate the total sqft) I now want to run a worksheet which allows me to summarise by name, count how many, give the sqft value of each and a total sqft. my database headers are =('Footprint'.'House Name') =COUNT =('Footprint'.'Area') =B2*C2 However when I use these the =('Footprint'.'Area') column automatically multiplies by count. any ideas how I can divide by count instead? I can't use the area tool as the sqft is calculated in a way that isn't directly linked to the symbol shape and needs to be a manual input. Quote Link to comment
michaelk Posted October 14, 2014 Share Posted October 14, 2014 It's strange that dividing by count doesn't work. However, there is a simple solution. 1. Select one of the row headers (on the left x.xx) 2. Drag the SUM badge into the column you want to summarize. (you've already done this part) 3. Drag the SUM badge into the column you DON'T want to summarize. i.e., the SQFT value. It will no longer add the values in that column. hth mk Quote Link to comment
Pat Stanford Posted October 14, 2014 Share Posted October 14, 2014 =B2*C2 as stated will obviously multiply. Did you perhaps mean =C2/B2 ??? Quote Link to comment
VW-PAD-Bristol-2014 Posted October 15, 2014 Author Share Posted October 15, 2014 Dragging the sum button seemed to work. Thank you. Quote Link to comment
Eva Eames Posted May 19, 2016 Share Posted May 19, 2016 I tried "=SUM(B16/B17)" in the cell, but it does't work for divide... Quote Link to comment
Pat Stanford Posted May 19, 2016 Share Posted May 19, 2016 Where did you put that formula. In the database header row? If you are just trying to divide two cells you don't need the SUM. If you want to get the sum of a bunch of database rows, put the formula B16/B17 in the database header. The header row will then automatically calculate the SUM of all of the rows in that column. Ask more if you still have questions. Quote Link to comment
Eva Eames Posted May 19, 2016 Share Posted May 19, 2016 Thank you for the quick answer. How about just adding two cells? for example, C15 AND C31, but not the cells in between them// Quote Link to comment
Pat Stanford Posted May 19, 2016 Share Posted May 19, 2016 Again, where are these cells? If they are in a database you put the formula =C15+C31 in the database header row. If they are just general cells, just put =C15+C31 in the cell where you want to sum. Quote Link to comment
Eva Eames Posted May 19, 2016 Share Posted May 19, 2016 The cells are in the regular worksheet. Quote Link to comment
Eva Eames Posted May 24, 2016 Share Posted May 24, 2016 I tried to look up subtraction, but I couldn't. I'm assuming the to subtract is to put =C3-D3 in the cell 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.