Averageifs... with date range.

[buzz71023]

I have the formula below that I got from help with here yesterday.
Now I am needing to add a date range to it.
If possible I would like for the user to be able to enter the date range in to Cells Y23 (start date) and Z23 (end date).

So in other words. the user will input his range into Y23 and Z23 and then the average will be taken like the formula.

thanks in advance.

=AVERAGEIFS(C:C,A:A,"GA 04",C:C,"<>0")

 

[AhoyNC]

Try:
=AVERAGEIFS(C1:C7,A1:A7,"GA 06",C1:C7,"<>0",Your date range,">="&$Y$23,Your date range,"<="&$Z$23)

 

[buzz71023]

Thanks for the reply but I have a question.
What is the "Your date range" for in the formula?
I am wanting the user to be able to change the date range by changing the date entered in Y23 and Z23.

 

[AhoyNC]

The date range is the column where your dates are located. You didn't state which column had the dates listed. The user would enter the start and end dates in Y23 & Z23.

 

[buzz71023]

Just realized I left a very important piece of information out of my original post.
Dates are populated in column B:B

 

[buzz71023]

Already answered.

thanks for the quick reply.

 

[AhoyNC]

You're welcome. Also, it usually best not to reference whole columns in a formula. If your data would never go below row 2000, then better to use something like A2:A2000 (assuming your data starts in row 2 with headers in row 1).