billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Hello All
My question this afternoon, Is there an alternate way to average December January & February
The formula I am using is
={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))}
<tbody>
</tbody>
My question this afternoon, Is there an alternate way to average December January & February
The formula I am using is
={SUM(SUMIFS($B$5:$B$16,$A$5:$A$16,{"December","January","February"}))/SUM(COUNTIFS($A$5:$A$16,{"December","January","February"}))}
January | 25 |
February | 36 |
March | 35 |
April | 24 |
May | 15 |
June | 18 |
July | 65 |
August | 25 |
September | 36 |
October | 45 |
November | 12 |
December | 32 |
<tbody>
</tbody>