ABS stack

[ChrisFoster]

Hi,

I could be barking up the wrong tree here and there be a simpler way to do this.

I have data in column D that contain positive and negative numbers (along with zeros). I want to SUM all the negative values so have used

SUMIF(D:D,"<0",D:D)

.
But I want it to show as a positive figure rather than negative, so have tried to stack that formula with the ABS function. I am getting no where fast.

Please can someone help?

Thanks,

Chris

 

[Fluff]

How about

=-SUMIF(D:D,"<0",D:D)

 

[ChrisFoster]

How about

=-SUMIF(D:D,"<0",D:D)

Thanks! That was so simple, I feel daft now.

 

[Legacy 143009]

Works fine for me. Strange..

Are you sure that you have real numbers, not texts?
( In Turkish yes, it is ABS(SUMIF()) )

 

[Fluff]

You're welcome & thanks for the feedback.