Choosing cells based on date...

  • Thread starter Carmen Gauvin-O'Donnell
  • Start date
C

Carmen Gauvin-O'Donnell

Hi! I have a cell that is supposed to add up two types of figures:
- two other numbers from different spreadsheets (I've figured that out!)

PLUS

a series of cells on this sheet, "up to the current date".

It's this last number I have no idea how to get.

We're not using date fields or anything either, just a simple column system
of
day of the week date amount which we modify month to month.

Is there a way of doing this?

Hopefully I'm relatively clear... Let me know if something doesn't make
sense. Wouldn't surprise me... it *is* Monday after all!

:)

Thanks in advance!

C.
 
D

Dave Peterson

maybe (just to get that last portion)...

=SUMIF(Sheet2!B:B,"<="&TODAY(),Sheet2!C:C)

I had the dates in column B of sheet2 and the amounts in column C of sheet2.
 
Top