Complete novece alert! Adding new rows stops formula working.

Hi everyone!
This is my first post here, and i am a complete novice in the world of excel so please accept my apologies
I have created a file for my father in law basically showing money paid in, money paid out and the total remaining.
The functions are all set up to calculate the total paid in, the total paid out and the total remaining, and they work fine reacting to any change i make within the table.
The problem begins when i need to add a new row at the bottom of the table, just above the total amounts. It seems that adding the new row brings up an error and the totals don't alter to show the values in the new row. Sometimes it will give me the option to include the new rows, but other times it does nothing, leaving me with incorrect calculations
Is there a way that i can set the file up so it automatically detects the data in the new row and adds it to the total?
Once a gain apologies if anything doesn't make sense.

Rich

Originally Posted by mrice

You could try totalling the entire column - Excel just ignores the blanks.

How would i do this please?

Thank you for the reply FDibbins, your method works a treat