Sum certain cells in different columns if the value is greater than zero

[chapysvp]

Hi

Hope you can help me with this:

I will give an example of what I want to do:

A1 B1 C1 D1 E1
10 5 -5 20 10

So I want to sum the values only in the cells A1,C1,E1 but only the ones that are greater than zero, in this example the result should be 20. Any suggestions??

Thanks for you help

 

[bhmcpfs]

There are probably easier ways, but this should work:

=SUMIF(A1,">0")+SUMIF(C1,">0")+SUMIF(E1,">0")

 

[chapysvp]

There are probably easier ways, but this should work:

=SUMIF(A1,">0")+SUMIF(C1,">0")+SUMIF(E1,">0")

Thank you bhmcpfs!

That will help me a lot

 

[bhmcpfs]

You're welcome, anytime.

Glad I could help.