Sum+IFERROR Help

You could try something like this:

=IF(SUM(O13:U13)-V13=0,"",IF(AND(O13<>0,COUNT(P13:V13)=0),"",IFERROR(SUM(O13:U13,-V13),"")))

Hope this helps.

Pete

Yes thats almost exactly what I want, is there anyway if o13 even contains a zero when the other cells have info that w13 will give a number based on the addition subtraction formula?
So if o13 is 0 and q13 is 1 and v13 is 1 i still get a number in w13? That would be amazing!

With those particular numbers, it is the first part of the formula which is causing your formula to return a blank, so maybe you want this:

=IF(COUNT(O13:V13)=0,"",IF(AND(O13<>0,COUNT(P13:V13)=0),"",IFERROR(SUM(O13:U13,-V13),"")))

Hope this helps.

Pete

Oh Ya thats it, nice work you're awesome?

Much Thanks,

CW

Thanks for feeding back. Why not click on a "star" as well as marking the thread as solved?

Pete

Do you mean the reputation star?

Yeah, don't worry about it though, as the Forum likes you to spread them around, so I don't think you can give consecutive reps to the same person.

Note, though, that you can click on the star icon on ANY post that you find helpful, even in threads that you have not contributed to.

Pete

Still wont let megive your more I can give it randomly to other people and then you again if you want?