Does anyone know why and exactly how CSE formulas and basic equivalents treat 0s differently?
For example, I am trying to average long data strings. If I do a {=AVERAGE(IF(Test!B4:B1001=Test!F4,Test!D4:D1001))} it averages differently than the simple average due to 0s in the lineup. Does anyone know how to remedy that?
For example, I am trying to average long data strings. If I do a {=AVERAGE(IF(Test!B4:B1001=Test!F4,Test!D4:D1001))} it averages differently than the simple average due to 0s in the lineup. Does anyone know how to remedy that?