Hi,

I can't figure out why is it that in some workbooks that I have, when I
enter additional row above Total row (which calculates sum), that Total row
includes the row I inserted, but some don't.
Example: I have invoices coming that I have to insert every day, so when I
insert another row for an invoice, cell that has SUM(D3:D25), doesn't change
to SUM(D3:D26). Sometimes it does, but only when I enter an amount into the
cell of inserted row, but in this particular workbook, it doesn't.
I need help with this, beacuse I don't want to have to change range every
time I insert a row.

Thanks a lot.