"Nicole" wrote:
=SUM(S5:X5)+IF(Q5<R5,R5-Q5,0)+IF(R5<Q5,R5-Q5,0)
I want to add if total is <=0 then =0

=MAX(0, SUM(S5:X5)+IF(Q5<R5,R5-Q5,0)+IF(R5<Q5,R5-Q5,0) )

But your two IF() expressions seem odd. Together, they say compute R5-Q5 if
R5 does not equal Q5, otherwise compute zero. But that is exactly what
R5-Q5 does.

I wonder if you want IF(Q5<R5,R5-Q5,0)+IF(R5<Q5,Q5-R5,0). But that is the
same as ABS(Q5-R5).