buffjoe311
New Member
- Joined
- Feb 24, 2009
- Messages
- 2
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.............
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.............