For the referencing #REF problem, use INDIRECT. E.g.,

=INDIRECT("A1")

will refer to cell A1 regardless of whatever rows you may insert or delete.
This is because Excel sees the "A1" as a simple character string, not an
actual cell reference, so it will not modify the text string as you
insert/delete rows/columns.

I'm not clear what you're looking for in the subtotals question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Cathi" wrote in message
...
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!!