Help with SUMIFS function transpose to 2003 Product

[kylelaporte]

I have the following function in an 2010 spreadsheet and need to use it on several work stations with 2003. Unfortunately the boss said no go on upgrading Office. I know a SUMPRODUCT or combination SUM and IF will work, just having trouble getting the correct transpose. Please help. Thanks

=SUMIFS('Daily Totals Input Sheet'!B:B,Dates,">="&DATE(YEAR(B6)-1,MONTH(B6)+1,DAY(B6)-1),Dates,"<="&DATE(YEAR(B6),MONTH(B6)+1,DAY(B6)-1))

 

[cyrilbrd]

Maybe =SUMPRODUCT(--('Daily Totals Input Sheet'!$B$2:$B$1000>=DATE(YEAR(B6)-1,MONTH(B6)+1,DAY(B6)-1)),--(Dates<=DATE(YEAR(B6),MONTH(B6)+1,DAY(B6)-1)))

 

[kylelaporte]

I get the dreaded #VALUE! error. I guess it would have helped to mention that the data in Column A "Dates" is date format with some blank cells. Column B is what I would like to sum based upon meeting the date criteria. I am trying to preserve a rolling 12 month summation from daily input numerical data.

 

[cyrilbrd]

Do you mean to say that 'Daily Totals Input Sheet'!$B$2:$B$1000 does not hold dates but values to be summed?

 

[kylelaporte]

Yes, but I just got it. Thanks

 

[cyrilbrd]

Glad you solved it. Thanks for the feedback.