Help with Conditional Function

[myamifin]

I am a relative newbie, and unsure of function use. I need to create a formula that will read 10 cells to verify that the entered amount is greater than 0 and if that is met than I want them to add the numbers together, but if not greater than 0 or no entry to skip. Can anyone help me out with this, as I have tried the IF function and am having an issue with setting up these parameters.
Thanks,

 

[lenze]

Hi and welcome to the board!!
You can use a simple SUMIF formula

=SUMIF(A1:A10,">0")

lenze

 

[myamifin]

Thank you for the information, how would I word it if the cells were not in order - example A7, C7, E7, G7, etc.