Sum total tons between specific dates, How?

[Odie]

I need to query columns to sum total weight between specific dates.
I would like to enter Begin Date in A1 and then End Date in A2 and have the Sum total on tons in A3. What would be the formula I need to put in A3?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My Dates are in G17:G5000
My Tons are in E17:E5000
<o></o>
Thank You, Odie

 

[delaneyjm]

Take a look at the SUMPRODUCT formula.

Give your sheet details, this should work in A3.

=SUMPRODUCT(--($G$17:$G$5000 > = A1),--($G$17:$G$5000 < = A2),E17:E5000)

 

[Akashwani]

Hi odie,

Something like this....

=SUMPRODUCT((G17:G5000>=A1)*(G17:G5000<=B1)*(Sheet2!$E$17:$E$5000))

Ak

 

[Odie]

Works great! Thank you both.
Odie