'How to get an average of multiple cells, while ignoring blanks and zeros when factoring the average
Trying to get monthly numbers average. But on weeks that have no numbers, because it is too early in the month there are no numbers for 2 weeks, for example. there is a Zero or NA in those cells. How would I calculate that so there Month ending Average does not give #Div/0! The multiple cells I’m averaging are not continuos and are on different sheets. I know AverageIF is the start.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|