Sum Postitive Values

[crysallisa]

Please advise how should I set the formula.

I have few values over several rows (A18, A29, A40, A51), and in cell A54, I
want to sum up the above cells that are in positive values and to excludes
any values that are less than 0.

 

[T. Valko]

One way:

=SUM((A18>0)*A18,(A29>0)*A29,(A40>0)*A40,(A51>0)*A51)

 

[Jacob Skaria]

Another one

=SUMPRODUCT((MOD(ROW(A18:A51),11)=7)*(A18:A51>0),A18:A51)

If this post helps click Yes

 

[crysallisa]

Hi Valko,

Thank you for great advice!! It solves my problem.

Best Regards
Crysallisa

 

[crysallisa]

Hi Jacob,

This method works too!.

Thank you!

Best Regards
Crysallisa

 

[T. Valko]

You're welcome. Thanks for the feedback!