Auto Sum On Excel Sheet

[hazelcs]

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 .

[Old_Geezer]

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 ?

[Tuvok]

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?