Sum data if dates in a column are w/in a specific range
:-) No Problem!
"Dhardy" wrote:
Please disregard previous question...sorry and thanks.
"Sean Timmons" wrote:
=SUMPRODUCT(--(A2:A1000=DATEVALUE("1/1/09"),--(A2:A1000<DATEVALUE("8/1/09"),M2:M1000)
=sumif(
"Dhardy" wrote:
I am trying to have Excel sum data in column M if data in column A is a
certain date range. Any tips/advice?
|