Okay, I am trying to revise a formula, and I am sure I am somewhat close, but, I just cannot get this to work properly. The formula I have right now is:

=SUMIF($E$7:$E$844,"<="&$A$1,$B$7:$B$844)

Column E is a list of quantities, in number format.

Column B is a list of dates, in date format (mm/dd/yy)

Cell $A$1 contains a date I want to reference. This date may be occassionally changed manually, which is why I am referencing a specific cell within my formula.

Based on the dates listed in Column E that meet the criteria of being less than or equal to the date listed in $A$1 I need to total the quantities listed in Column B.

Thanks in advance for all your help!

=SUMIF($E$7:$E$844,"<="&$A$1,$B$7:$B$844)

Column E is a list of quantities, in number format.

Column B is a list of dates, in date format (mm/dd/yy)

Cell $A$1 contains a date I want to reference. This date may be occassionally changed manually, which is why I am referencing a specific cell within my formula.

Based on the dates listed in Column E that meet the criteria of being less than or equal to the date listed in $A$1 I need to total the quantities listed in Column B.

Thanks in advance for all your help!

## Comment