|Can anyone explain why the following formula doesn't work?|
The cell remains blank if value is zero, which is great. However, it only returns the value of C20 instead of adding the range C13:C20.
If C13 = 1, C14=2, C15=2, C16=1, C17=6, C18=2, C19=2, C20=1
The formula returns 1?