how do i get a formula to ignore minus figures

M

marto_martin

Ok here goes...
A1 = $0.09, A2 = $0.10, A3 = -$0.04 and A4 = $0.06.
I want the sum to ignore the minus figure and only calculate the plus
figures...therefore equaling $0.25

Is this possible?
Cheers
 
M

Max

One way ..

Put in A5: =SUM(IF(A1:A4>0,A1:A4))
Array enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
 
F

Frank Kabel

Hi
you have already several responses to your original thread. e.g. use
=SUMIF(A1:A4,">0")
 

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

Similar Threads

how do i get a formula to ignore minus figures 7
FORMULA WHICH IGNORES POSITIVE VALUES 2
Creating a formula relating to several cells 2
Help Creating Excel Formula 4
Mandatory and optional formula 5
How can I add numbers but ignore the minus signs? 2
series of formulas to get to one formula 0
Ignore blanks in multiplication formula 4

Top