Sum based on date range

[statenja]

I would like to have cell G3 automatically sum the values in Column B based on the start and end date parameters that are typed in the cells (E3 and E4). Does someone know a formula that will work for this?

[Paul]

Hi Statenja,

You can use a few formulas, for example:

=SUMIF(A2:A10,">="&E3,B2:B10)-SUMIF(A2:A10,">"&E4,B2:B10)

or

=SUMPRODUCT((A2:A10>=E3)*(A2:A10<=E4),B2:B10)

[statenja]

Thanks for the help and rapid response!