Range Totals?

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
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a monthly running total 3
Rolling 12 month total 7
Summing a non continuous range 7
ytd totals for multiple years 2
Formula 2
SUMIF 1
Adding Regressive Months Totals 2
How do I get a new calculated date from different date ranges? 3

Top