I had trouble getting the SUM of a column that also contained #N/A! errors.

I solved it with the following formula


however, I only want to SUM positive values. When I add "<0" I get an error.

How can I modify this formula to only SUM positive values?


1 Answer 1


Use filter(), like this:

=sum( iferror( filter(A1:A20, A1:A20 > 0) ) )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.