It works for me (insert, and on enter amount it adjusts the formula)
*unless* I insert multiple lines and complete them out of sequence.
Then, once the sequence is broken, the formula remains at fault until
the formula is amended.

Would that be your reason too?

--

umba-sr Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532549