Forum Discussion
Maddy1010
Feb 20, 2023Brass Contributor
finding averages
Hello. I am struggling to find a formula that will work for all cells, in the yellow columns. The objective is to return an average, even if sometimes the total is 0 in some months. The issu...
HansVogelaar
Feb 20, 2023MVP
The solution proposed by durendal will include the months with a total of 0 in the average; it counts them as 0. If you want to exclude such months, see the attached version; I added some helper columns.
- Maddy1010Feb 21, 2023Brass ContributorThanks Hans!