Absolute Values

[maldonadocj]

Hello,

I need assistance with a calculation. I have set of numbers that may be positive or negative for each unique identifier. I need to have Excel or Access calculate the sum of the positive values only. Example noted below:

Cell A1: xyz corp
Cell B1: 50,000,000
Cell C1: -25,000,000
Cell D1: 50,000,000

Expected sum results=100,000,000

Thank you!

 

[Domenic]

Try...

=SUMIF(B1:D1,">0")