Summing values for a range of dates
 

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

Summing values for a range of dates
 

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

Summing values for a range of dates
 

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