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.
|