Do not count minus-numbers

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

SpookiePower

I have some number I would like to SUM, but I dont want excel to
calculate the minus-number.

Here is what I have -

A1 10
B1 20
C1 30
D1 40
E1 -1000
F1 0
G1 0


I do it like this SUM(A1:G1)

But I want it to say SUM(10+20+30+40+0+0)
How can I do it like that ?
 
Back
Top