I am need to create a sheet on which I can track 2 different totals in the
same column.

I need to be able to put multiple entries in and add them up as a sub total
of the new entries and then an overall total of all entries.
Ex:

Column A is a date column and column B is an inventory rec'v count

So C3=the subtotal of the new entries and C1= the overall total.

Is this even possible?

Any suggestions? I'm desperate as my boss is convinced that this is possible
in Excel.

I can't even seem to make my cell references absolute ...

I can't get the formula =$C$4 to point to an absolute cell reference so that
I can delete row 4 and the following row is brought up, now becoming row 4
and have the formula recognize it as such, I get #REF!

Again my boss is convinced that one is able to delete the referenced row and
it should just automatically update.

Am I missing something really blatant?

HELP!!