Do not count minus-numbers

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top