Range Totals?

  • Thread starter Thread starter carly
  • Start date Start date
C

carly

I have a worksheet with the months running along the top,
under each month is a value.

Currently i have a running total thats works by summin up
all the months, but this only works because i never enter
values ahead of their time eg i can only enter values up
until the month that it currently is.

If i want to be able to enter future values, i.e. for june
or july 2004 - BUT FOR THEM NOT TO AFFECT THE RUNNING
TOTAL UNTIL THAT TIME - how would i go about achieving
this?
Regards
carol
 
One way

=SUMIF(A2:A100,"<"&TODAY(),B2:B100)

will sum values in B where dates are prior to today in A
adapt to fit your particular tables
 
Back
Top