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

As long as the dates involved are all proper dates (not text) then:
=SUMPRODUCT(--($AA$10:$BE$10<=B6),$AA$12:$BE$12)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119196

Thanks mate, perfect!

"p45cal" wrote:


As long as the dates involved are all proper dates (not text) then:
=SUMPRODUCT(--($AA$10:$BE$10<=B6),$AA$12:$BE$12)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119196