how do I default sum to 0 for negative numbers in excel

[tjtjjtjt]

One way"
If(SUM(A1:A10)<0,0,SUM(A1:A10))

tj

 

[Don Guillett]

Try

=MAX(0,SUM(F2:F300))

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(--(A1:A10>0),A1:A10)


Arvi Laanemets