View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathi Cathi is offline
external usenet poster
 
Posts: 8
Default Urgent! I am in dire trouble - boss says it can be done - How?

Like a dream, a few adjustments for cell refernces and ta da!!!

I cannot thank you enough , I've spent too much time trying to figure this
out and was thinking way way too hard.

My humble gratitude

"Pete_UK" wrote:

You can probably use SUMIF to get your subtotal, by comparing the
dates against another date (TODAY ?) which determines what is new. Put
your reference date in D1, then put this in C3:

=SUMIF(A1:A100,"="&D1,B1:B100)

I've assumed 100 entries - adjust to suit. This looks at your dates in
column A, compares them with the date in D1, and adds up column B
entries where the date is later than or equal to the date in D1.

Hope this helps.

Pete

On Oct 7, 12:37 am, Cathi wrote:
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!!