Sum data if dates in a column are w/in a specific range
=SUMPRODUCT(--([Book1]Sheet1!A2:A1000=DATEVALUE("1/1/09"),--([Book1]Sheet1!A2:A1000<DATEVALUE("8/1/09"),[Book1]Sheet1!M2:M1000)
Of course, change Book1 and sheet1 to your workbook and sheet names.
It's actualyl easiest if you enter sumproduct( then click the Fx in yoru
address bar. Then, you can just cick and drag your sets desired and the
workbook and sheet will automatically show...
"Dhardy" wrote:
What do I need to change in the formula that you provided if I am evaluating
data from another workbook?
"Sean Timmons" wrote:
:-) 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?
|