Running totals with forecasted data.

[mikedmoon]

Hi There!

I'm trying to figure out how to get a running total based on date (in this case, everything up until yesterday). On the attached file you'll see that I've got data for every day of the month, another from today forward is a forecast, everything before today is an actual (the file it pulls from is a ridiculously large pivot table so I'm trying to make something a little more managable). I'm thinking there is a super simple solution to this that I'm missing because I'm over thinking this. An ideas?

[mikedmoon]

And of course the moment I hit submit, it hit me:

=SUMPRODUCT((B2:AF2<TODAY())*(B3:AF3))

[FDibbins]

always a good feeling when you can solve your own questions