Donate SIGN UP

Auto Sum On Excel Sheet

Avatar Image
hazelcs | 15:51 Wed 23rd Nov 2016 | Computers
2 Answers
Hi hubby doing treasurers post for bowl club and he keeping figures on computer libre office. He can get a few rows to add up in auto sum for a month but when he tries to add up every months incoming and outgoing transactions it only does the rows not already included in previous months totals. He is high lighting the first subtotal and dragging it down the page any other ideas? Thanks .
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by hazelcs. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
I find it difficult to visualise what he is doing.
He has a row per month and a cell that sums the row.
He then does what ? Sums the column of monthly totals ?
Instead of dragging why not type in the formula needed ?
Lets assume you have 5 columns by 5 rows - starting in column A and row 2 - with row 1 being the header eg.

Jan. Feb. Mar. Apr. Subtotal
1. 2. 3. 4. formula would be something like =SUM(A2..D2)
2
3
4
=SUM(A2..A4)


Is this what he's trying to do?

1 to 2 of 2rss feed

Do you know the answer?

Auto Sum On Excel Sheet

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.