Dear all,
First post so please forgive lack of experience.
I've searched the forum and found many answers that seem to nearly fit my problem, but haven't been able to find a solution that works for me. Hopefully my description of my problem will mean someone can suggest a solution.
I'm looking for formula that will retrieve the average value of a set of cells that are adjacent to cells that meet a particular criteria. Let me elaborate....
My data is arranged as such:
Column A = Month
Column B = Day of the month
Column C = Recorded measurement (temperature)
Therefore, cells A2:A32 contain "Jan-06", cells B2:B32 contain the numbers 1-31 sequentially, cells C2:C32 contain a number representing the measurement. I have four years of data, so in total their are 1461 rows (4 x 365 + 1 header).
What I want is to calculate mean monthly temperature from these daily values.
Obviously, I could sort by the month and copy&paste into separate files but this would be time consuming (I have more data to process that stated here).
What I would like to have is a formula that will take the average of all the C cells that are adjacent to an A cell that contains the month I am interested.
I think some of the lookup functions embedded in a average function might work but I haven't the skill to make it successful.
Any advice or suggestions would be very welcome.
First post so please forgive lack of experience.
I've searched the forum and found many answers that seem to nearly fit my problem, but haven't been able to find a solution that works for me. Hopefully my description of my problem will mean someone can suggest a solution.
I'm looking for formula that will retrieve the average value of a set of cells that are adjacent to cells that meet a particular criteria. Let me elaborate....
My data is arranged as such:
Column A = Month
Column B = Day of the month
Column C = Recorded measurement (temperature)
Therefore, cells A2:A32 contain "Jan-06", cells B2:B32 contain the numbers 1-31 sequentially, cells C2:C32 contain a number representing the measurement. I have four years of data, so in total their are 1461 rows (4 x 365 + 1 header).
What I want is to calculate mean monthly temperature from these daily values.
Obviously, I could sort by the month and copy&paste into separate files but this would be time consuming (I have more data to process that stated here).
What I would like to have is a formula that will take the average of all the C cells that are adjacent to an A cell that contains the month I am interested.
I think some of the lookup functions embedded in a average function might work but I haven't the skill to make it successful.
Any advice or suggestions would be very welcome.