SUMIFS + condition on result

**Davzx** · 06-28-2012, 12:40 PM

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.

**Haseeb Avarakkan** · 06-28-2012, 12:50 PM

Hello,

try with MAX,

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

**SteveG** · 06-28-2012, 12:50 PM

Hi,

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

HTH
Steve

**martindwilson** · 06-28-2012, 12:51 PM

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))