Hi,
I need a formula to calculate the average value of a column given a month/year.
<tbody>
</tbody>
Averageifs moth = 3 and year 2014 = 10 + 20 + 30 / 3 = 20
Averageifs moth = 4 and year 2014 = 30 + 50 / 2 = 40
Thanks.
I need a formula to calculate the average value of a column given a month/year.
03/15/2014 | 10 |
03/20/2014 | 20 |
04/10/2014 | 30 |
04/18/2014 | 50 |
06/30/2014 | 30 |
<tbody>
</tbody>
Averageifs moth = 3 and year 2014 = 10 + 20 + 30 / 3 = 20
Averageifs moth = 4 and year 2014 = 30 + 50 / 2 = 40
Thanks.