Hi there,

I am having a problem uding the sum if function to automatically calculate a
rolling actual vrs budget scenario. the details a

in B6, todays date (manually entered)

In Columns AA through to BE in Row 10 I have the date range from 01/07/09
throgh to 31/07

in the same columns in row 12 i have the budget values

What I am trying to do is have a rolling MTD date figure for the budget for
example if the date was the 05/07 when this is entered in cell B6, the
formula willl sum all values from the dates 01/07 throgh to 05/07. (Columns
AA - AE) and so on.

Other people will be using it on a daily basis so want to saty away from add
ins and macros if possible.

Would appreciate some hlpe if possible!

Many thanks

Campbell