lukertomlinson99
New Member
- Joined
- Nov 6, 2023
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hello, I am struggling to get a formula to work in which it calculates an average of specific cells (A1, E1, F1 etc) rather than a range (A1:F1 e.g.). I want this to be able to ignore the cells containing 0 as it skews the average I want at the end. This is to calculate an average grade for pupils across a year but them having 0 in some cells that will be autopopulated across the year skews it so they seem to be doing terribly. Any thoughts would be appreciated sorry if this doesn't make sense.