indiemusicboy
New Member
- Joined
- Apr 9, 2020
- Messages
- 47
- Office Version
- 365
- Platform
- MacOS
I am trying to average a single cell across multiple worksheets between First and Last tabs. The current formula, =AVERAGE(First:Last!G116), works but it is taking into account "0" values. I want the formula to omit the cells that are zero. However =AVERAGEIF(First:Last!G116,"<>0") returns an error. Any ideas?