Prevent Worksheets From Summarizing

[Greg_at_ils]

I have a worksheet that is summarizing it's contents by one text field, "Type Code".

Is there a way to prevent other numeric fields from summarizing their data?

Thanks!

[Pat Stanford]

If you only have a few fields, you can drag SUM tiles to those columns as well and it will then "unsum" those values.

If you have lots of columns, then you will need to edit the formulas.

Put in a new column with a formula of =count

This will get you the number of items that are summed in that row.

If your count formula is in column D and the database if row 4 then edit the formulas for the numeric columns to be (for example) =door.width/D4.

This will get you the average width of the doors. If they are all the same it will get you the width of the doors.

I recommend you save your extra SUM icons for columns that will have different values as it will split them out.

[Greg_at_ils]

How many SUM columns can I have?

[Pat Stanford]

Maximum of 3

[Greg_at_ils]

That's unfortunate. Such as simple thing can cause so much extra time. It would be nice if they raised that limit or added a separate function to remove the summary from selected columns.