Forum Discussion
mazloum91
May 23, 2023Copper Contributor
Calculating an Average based on changing values
In my budget spreadsheet, I am trying to determine an "On Pace For" value for each spending category. I want this "On Pace For" value to take the average of the months that are not zero and multiply ...
HansVogelaar
May 23, 2023MVP
=AVERAGE(IF((E5:AA5>0)*ISODD(COLUMN(E5:AA5)),E5:AA5))*12
If you do not have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.