loudnoiseman
Board Regular
- Joined
- Dec 31, 2004
- Messages
- 218
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I'm trying to figure out how to make the count formula only account for numbers above or below zero but not zero itself.
For my purposes each instance where there is a zero essentially is not a factor to be considered yet it is factored in and thus throws off my expected result.
As an example, a range of cells containing 1 through 10 averages 5.5 but if I replace 3 & 7 with 0 then the average changes to 4.5 but if I deleted 3 & 7 then it's 5.625
Thanks!
I'm trying to figure out how to make the count formula only account for numbers above or below zero but not zero itself.
For my purposes each instance where there is a zero essentially is not a factor to be considered yet it is factored in and thus throws off my expected result.
As an example, a range of cells containing 1 through 10 averages 5.5 but if I replace 3 & 7 with 0 then the average changes to 4.5 but if I deleted 3 & 7 then it's 5.625
Thanks!