how do i get a formula to ignore minus figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Hi
you have already several responses to your original thread. e.g. use
=SUMIF(A1:A4,">0")
 
Back
Top