SUMIF if a cell is not equal to a value

**Hodge1013** · 08-29-2017, 06:55 PM

I want to add C3+D3+E3 if A3 is not 793 and if it is just 793 then leave it blank in G3 and so on down column G

**jeffreybrown** · 08-29-2017, 07:02 PM

Are you looking for =IF(A3<>793,SUM(C3:E3),"")

**Hodge1013** · 08-29-2017, 09:15 PM

Thank you!!!

**Hodge1013** · 08-29-2017, 09:19 PM

How about if i wanted it to also not sum if it says 794?

**Hodge1013** · 08-29-2017, 09:24 PM

its returning 0 when all other cells are blank, how do i fix it to be blank if they are?

**jeffreybrown** · 08-29-2017, 09:36 PM

Try in G3 copied down...

=IF(AND(A3<>793,A3<>794,COUNT(C3:E3)=3),SUM(C3:E3),"")

**Hodge1013** · 08-29-2017, 09:44 PM

Thanks a bunch!!

**jeffreybrown** · 08-29-2017, 09:53 PM

You are very welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: SUMIF Help Please