how do i get a formula to ignore minus figures

[marto_martin]

As mentioned above, if A1 =$0.09, A2 =$0.05, A3 = -$0.04, A4 =$0.06
I want A3 to be ignored and therefore the formula result should be $0.20

 

[Aladin Akyurek]

=SUMIF(A1:A4,">0")

 

[Gord Dibben]

marto

=SUMIF(A1:A4,">0")

Gord Dibben Excel MVP

 

[Ashish Mathur]

Hi,

try this. Array enter the foll. formula (Ctrl+Shift+Enter)

SUM(IF(range>0,range,0))

Regards,

Ashish Mathur

 

[marto_martin]

Just gave this a try and got an error
"a value used in the formula is of the wrong data type"


:

=SUMIF(A1:A4,">0")

 

[Aladin Akyurek]

Can you copy the exact formula you used from the Formula Bar and post it in
the follow-up.

 

[marto_martin]

Got it to work using
SUMIF(range,">0",range)

Thanks muchly for ya help

 

[Ken Wright]

No reason you should need the optional last argument if the Sum range is the
same as the first.