Average Number(formula found) of Column Only in Date Range from Other Column

[wmunsey81]

Here is the Logic:

Repair DB in Excel.

Column H contains Request Date

Column AG contains Return Date

Column BD contains Range AG - Range H only if Column O (Property #) is not 1918.

This part works just fine and exactly what I need, for example:

=IF(AG2484="","",IF(O2484<>1918,AG2484-H2484,""))

This is what I am wanting. I am able to find the average of BD which gives me numbers no problem: =AVERAGE(BD6:BD2505)

What I need to do is find 2 items, and I think if I find one the other will flow with the same kind of code, is to find volume and average per quarter of year.

This would probably include a IF statement that would look up value of Column H and if falls in certain range, it would count and then take those average of number range.

I also made a set of 8 date ranges (2 columns) of start and finish of each quarter if that helps.

Any help would be awesome!

 

[arthurbr]

You could use a Pivot Table
or
the AVERAGEIFS function