Excel Help.xlsx

Hello,

I am trying to figure out how to write a formula that takes the average of the most recent 6 months of column I, "Cost per Unit," while pulling the data based on column A, "Meter Number."

The goal is to be able to just edit the search criteria for different meter numbers to then pull the 6 month average without having to write separate formulas for each Meter's set of data.

I realize my explanation might not be the best and apologize in advance for this but any help would be much appreciated!

Sincerely,
BoneyLit