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
Bookmarks