Hello everyone,

I have a tricky question that I can't find the answer to no matter how hard I google.

I have a long list of numbers, and I need to summarize them in such a way that whenever it dips below 0, it gets treated as zero.

For example, if the list is

10
-20
10

then the result should be 10, rather than 0

As the list is quite long, if(if(A1+A2<0, "0",A1+A2)+A3... wouldn't work unfortunately.

Thanks a lot
Zandi