Cell Reference a date in SumIf function

[buffjoe311]

Hello all,

This is my first post because I can usually just search to find answers, but not for this one. My problem is:

I have a SumIf formula to add up quantities that occurred between two specific dates. The formula works when I enter the dates manually, but I cannot get it to work when trying to reference the cells with the date in them. Here is the formula:

=SUMIF('Actual HDD'!$A$2:$A$65536,"<01/28/2009",'Actual HDD'!$B$2:$B$65536)-SUMIF('Actual HDD'!$A$2:$A$65536,"<12/29/2008",'Actual HDD'!$B$2:$B$65536)


I'd like to cell reference the highlighted blue part with the "<".
Please help, this is creating waaaaaay too much manual labor.

Thanks.............

 

[Jonmo1]

Welcome to the board...

Try

=SUMIF('Actual HDD'!$A$2:$A$65536,"<"&A1,'Actual HDD'!$B$2:$B$65536)-SUMIF('Actual HDD'!$A$2:$A$65536,"<"&B1,'Actual HDD'!$B$2:$B$65536)
A1 = 01/28/2009
B1 = 12/29/2008

Hope that helps...

 

[buffjoe311]

WOW!!! You made my day.....for future reference, what is the "&" symbol's function. That was prob the only thing I haven't tried.


thank you thank you thank you

 

[lenze]

The & acts as a concatinating operative, joining the "<" and A1 together as a single enity
lenze