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.

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

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

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

5. Re: SUMIFS + condition on result

Thank you very much, works great.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1