We are trying to calculate the average of each months of the years using the formula "=AVERAGE
". Unfortunately, it's not working. We tried also "=SUMPRODUCT
" but can't seem to get it accomplish.
In the included excel, notice that the formula displays and next to it what we calculate manually (see pic):
Please advice on the formula to use.
Thank you in advance.