Software

Ask something
Discussion Locked

excel question

0 helpful
1 reply

by djcarwax

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
what is the formula to totaling up tables automatically?

1 reply

by dklippert

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.

This discussion is closed to new replies.