General discussion

Locked

excel question

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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| 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:
=SUM(A1:A30)
Or:
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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums