yannidakisCopper ContributorJan 20, 2023SolvedSum only if there is no zero Greetings all! I want to sum to cells (eg X16+Y16) but is one of them's value = zero, then it will return zero example 1; 1 + 5 = 6 example 2; 1 + 0 = 0 Show MoreDetlef_LewinJan 20, 2023yannidakis There are many ways.=SUM(X16:Y16)*NOT(COUNTIFS(X16:Y16,0))
Detlef_LewinSilver ContributorJan 20, 2023yannidakis There are many ways.=SUM(X16:Y16)*NOT(COUNTIFS(X16:Y16,0))
