Sum Postitive Values
 

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.

Sum Postitive Values
 

One way:

=SUM((A180)*A18,(A290)*A29,(A400)*A40,(A510)*A 51)

--
Biff
Microsoft Excel MVP


"crysallisa" wrote in message
...
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.

Sum Postitive Values
 

Another one

=SUMPRODUCT((MOD(ROW(A18:A51),11)=7)*(A18:A510),A 18:A51)

If this post helps click Yes
---------------
Jacob Skaria


"crysallisa" wrote:

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.

Sum Postitive Values
 

Hi Valko,

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

Best Regards
Crysallisa

"T. Valko" wrote:

One way:

=SUM((A180)*A18,(A290)*A29,(A400)*A40,(A510)*A 51)

--
Biff
Microsoft Excel MVP


"crysallisa" wrote in message
...
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.

Sum Postitive Values
 

Hi Jacob,

This method works too!.

Thank you!

Best Regards
Crysallisa

"Jacob Skaria" wrote:

Another one

=SUMPRODUCT((MOD(ROW(A18:A51),11)=7)*(A18:A510),A 18:A51)

If this post helps click Yes
---------------
Jacob Skaria


"crysallisa" wrote:

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.

Sum Postitive Values
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"crysallisa" wrote in message
...
Hi Valko,

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

Best Regards
Crysallisa

"T. Valko" wrote:

One way:

=SUM((A180)*A18,(A290)*A29,(A400)*A40,(A510)*A 51)

--
Biff
Microsoft Excel MVP


"crysallisa" wrote in message
...
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.