Averageifs Question

[rhowell79]

Using Office 2010, I am trying to do a averageifs formula for a specified date range. I can get it working by specifying the date range in the formula itself, however when "pointing" the formula to a specific cell with a date in it, the formula gives me a div/0 error.

Formula that works is:
=AVERAGEIFS('UHP Weld Data'!M:M,'UHP Weld Data'!B:B,"<09/28/2012",'UHP Weld Data'!B:B,">08/29/2012")

What I need is a version of: (currently not working)
=AVERAGEIFS('UHP Weld Data'!M:M,'UHP Weld Data'!B:B,"<G1",'UHP Weld Data'!B:B,">H1")


The date range will constantly change as I want it to show me the past 30 days only.

Any help is appreciated!

Thanks,
Robert

 

[T. Valko]

Using Office 2010, I am trying to do a averageifs formula for a specified date range. I can get it working by specifying the date range in the formula itself, however when "pointing" the formula to a specific cell with a date in it, the formula gives me a div/0 error.

Formula that works is:
=AVERAGEIFS('UHP Weld Data'!M:M,'UHP Weld Data'!B:B,"<09/28/2012",'UHP Weld Data'!B:B,">08/29/2012")

What I need is a version of: (currently not working)
=AVERAGEIFS('UHP Weld Data'!M:M,'UHP Weld Data'!B:B,"<G1",'UHP Data?!B:B,? Weld>H1")


The date range will constantly change as I want it to show me the past 30 days only.

Any help is appreciated!

Thanks,
Robert

You have 2 dates so you need to point to 2 cells.

G1 = 8/29/2012
H1 = 9/28/2012

=AVERAGEIFS('UHP Weld Data'!M:M,'UHP Weld Data'!B:B,">"&G1,'UHP Weld Data'!B:B,"<"&H1)