m | n | |
13 | 90 | |
14 | 91 | |
15 | 92 | |
16 | 92 | |
17 | 365 | |
18 | 33 | 37% =m18/m13 |
19 | 0 | |
20 | 0 | |
21 | 0 | |
22 | 33 | 814% |
<tbody>
</tbody>
- n22 should be 37%
- n22: 9% -- includes zeros, delivers a wrong percentage
=m22/m17 - n22: 814% -- Trying to avoid zeros, delivers a wrong percentage.
=SUMPRODUCT(m18:m21,m13:m16)/SUMPRODUCT(--(m18:m21<>""),m13:m16)