General discussion


excel question

By djcarwax ·
what is the formula to totaling up tables automatically?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to excel question

Select a cell at the bottom of a column of numbers and Click on the Autosum icon on the toolbar (?)
The formula is:
Sort your data into logical groups, Months, Products, Names, etc.
Choose one cell in the list and go to Data>Subtotals
You can create Grand totals and subtotals whenever there is a change of name.

Related Discussions

Related Forums