Another Worksheet Question - Dividing by count?

[VW-PAD-Bristol-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.

[michaelk]

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

[Pat Stanford]

=B2*C2 as stated will obviously multiply.

Did you perhaps mean

=C2/B2

???

[VW-PAD-Bristol-2014]

Dragging the sum button seemed to work.

Thank you.

[Eva Eames]

I tried "=SUM(B16/B17)" in the cell, but it does't work for divide...

[Pat Stanford]

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.

[Eva Eames]

Thank you for the quick answer. How about just adding two cells? for example, C15 AND C31, but not the cells in between them//

[Pat Stanford]

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.

[Eva Eames]

The cells are in the regular worksheet.

[Eva Eames]

I tried to look up subtraction, but I couldn't. I'm assuming the to subtract is to put =C3-D3 in the cell