# SUMIFS + condition on result

1. ## SUMIFS + condition on result

Hello,

This is the problem, i need all results from SUMIFS formula that are zero to be 1. Example in attachment.
In sheet List2, cell c3 result is 0, when that is the case i need it to be 1. Is there a simple solution to this?

Any help is appreciated.  Register To Reply

2. ## Re: SUMIFS + condition on result

Hello,

try with MAX,

=MAX(1,SUMIFS(List1!C\$3:C\$28, List1!A\$3:A\$28, A2,List1!B\$3:B\$28, 11))  Register To Reply

3. ## Re: SUMIFS + condition on result

Hi,

Try,
=MAX(SUMIFS(List1!C\$3:C\$28, List1!A\$3:A\$28, A2,List1!B\$3:B\$28, 11),1)

HTH
Steve  Register To Reply

4. ## Re: SUMIFS + condition on result

if the answer is always an integer >=1 or 0
=max(1,"mysumifformula")
if its not then
if(SUMIFS(List1!C\$3:C\$28, List1!A\$3:A\$28, A2,List1!B\$3:B\$28, 11)=0,1,SUMIFS(List1!C\$3:C\$28, List1!A\$3:A\$28, A2,List1!B\$3:B\$28, 11))  Register To Reply

5. ## Re: SUMIFS + condition on result

Thank you very much, works great.  Register To Reply