Summing values for a range of dates

[Campbell]

Hi there,

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

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

 

[p45cal]

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

 

[Campbell]

Thanks mate, perfect!