Sum only if there is no zero

[yannidakis]

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

[#2 · Accepted solution]

@yannidakis 

There are many ways.

=SUM(X16:Y16)*NOT(COUNTIFS(X16:Y16,0))

[#3]

Perfect, thank you so much!