Extract and average a number of unique values selected by rows matching set criteria

[Gareth33]

I have a file containing rainfall data for each day over many years and am trying to automate calculation of the average rainfall on any given day.

Data is structured like this:

Row	Col C	Col D	Col E	Col F
1	Year	Month	Day	Rainfall
1000	2015	12	4	0.4
1365	2016	12	4	1.3

<tbody>
</tbody>

and required result would be the average of all the values in Col.F for a given month and day. I'd like to tabulate results in a new sheet with a row for each date through the year, e.g.

Jan-1, 0.0
Jan-2, 0.5
Jan-3, 0.2 etc.

I've got rather lost due to the number of loops. If anyone could show me a way to do this it would be much appreciated.

 

[tusharm]

Just use a PivotTable and let Excel do the hard work. Put the year, month, and date as row fields and the Rainfall as the data column. Change, if necessary, the type of statistic (default is likely to be COUNT or SUM) to Average.

I have a file containing rainfall data for each day over many years and am trying to automate calculation of the average rainfall on any given day.

Data is structured like this:

Row	Col C	Col D	Col E	Col F
1	Year	Month	Day	Rainfall
1000	2015	12	4	0.4
1365	2016	12	4	1.3

<tbody>
</tbody>

and required result would be the average of all the values in Col.F for a given month and day. I'd like to tabulate results in a new sheet with a row for each date through the year, e.g.

Jan-1, 0.0
Jan-2, 0.5
Jan-3, 0.2 etc.

I've got rather lost due to the number of loops. If anyone could show me a way to do this it would be much appreciated.