Google Sheets - Include cells with zero values in any calculation
E
Edison Lopez
- Do not ignore cells with zero value
- Example:
Google Sheets has 3 parameters with 3 different values
Value A = 1
Value B = 3
Value C = 0
To calculate the average, we take Value A and Value B, and exclude Value C: (1+3)/2 = 2
This feature request is to also count Value C toward the AVG calculation: (1+3+0)/3 = 1,33
Log In