Microsoft Office Questions? Ask a IT Expert for Support ASAP
Please attach the file here using the paperclip icon so I may see...
i have the sheet.
You want to get the average of values from column I that fall with in - 3 months of all of the values for the dates in column D? So if you have 5 dates that fall with march,april,may, you want the average of just those five values?
Am I correctly following?
what is a geometric mean?
doesn't really help me,
but lets look at your criteria, and assume excel calculates the correct value if you plug in the correct numbers.
You want to look at the values in column I for a 3 month period prior to the date in a given row for column D?
so you no longer want help on this?