Hi, I'm looking for a formula which will add together all of the values from
a range if they are negative... (only if they are negative)
So far, I've used the countif function to count how many positive and
negative results are recorded. - okay for the project at the moment, as
values 1 or -1 or 0 will be entered into system, so counting negative values
is the same thing, however if -3 points is entered into the range, this
obviously doesn't work...

I'm normally okay with excel formulas, just need a little push in the right
direction,

thank you for any help you can provide.


--
Dan Walters

=SUMIF(range,"<0")

"DanielWalters6" wrote:

Hi, I'm looking for a formula which will add together all of the values from
a range if they are negative... (only if they are negative)
So far, I've used the countif function to count how many positive and
negative results are recorded. - okay for the project at the moment, as
values 1 or -1 or 0 will be entered into system, so counting negative values
is the same thing, however if -3 points is entered into the range, this
obviously doesn't work...

I'm normally okay with excel formulas, just need a little push in the right
direction,

thank you for any help you can provide.


--
Dan Walters

Use SUMIF instead of COUNTIF - it has 3 parameters, like this:

=SUMIF(condition_range,"<0",sum_range)

although in your case sum_range might be the same as condition_range, so it
could be omitted and would therefore look very similar to a COUNTIF formula.

Hope this helps.

Pete

"DanielWalters6" wrote in message
...
Hi, I'm looking for a formula which will add together all of the values
from
a range if they are negative... (only if they are negative)
So far, I've used the countif function to count how many positive and
negative results are recorded. - okay for the project at the moment, as
values 1 or -1 or 0 will be entered into system, so counting negative
values
is the same thing, however if -3 points is entered into the range, this
obviously doesn't work...

I'm normally okay with excel formulas, just need a little push in the
right
direction,

thank you for any help you can provide.


--
Dan Walters

=SUMIF(A1:A100,"<0") will return the sum of negatives as negative number

=ABS(SUMIF(A1:A100,"<0")) will return the sum of negatives as positive number


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 16:17:01 -0700, DanielWalters6
wrote:

Hi, I'm looking for a formula which will add together all of the values from
a range if they are negative... (only if they are negative)
So far, I've used the countif function to count how many positive and
negative results are recorded. - okay for the project at the moment, as
values 1 or -1 or 0 will be entered into system, so counting negative values
is the same thing, however if -3 points is entered into the range, this
obviously doesn't work...

I'm normally okay with excel formulas, just need a little push in the right
direction,

thank you for any help you can provide.

Thank you all for your help!
I wan'st aware of SUMIF - Was trying to build an IF statement, which if
conditions matched added it to a total variable.

Thank you again

Dan
--
Dan Walters


"DanielWalters6" wrote:

Hi, I'm looking for a formula which will add together all of the values from
a range if they are negative... (only if they are negative)
So far, I've used the countif function to count how many positive and
negative results are recorded. - okay for the project at the moment, as
values 1 or -1 or 0 will be entered into system, so counting negative values
is the same thing, however if -3 points is entered into the range, this
obviously doesn't work...

I'm normally okay with excel formulas, just need a little push in the right
direction,

thank you for any help you can provide.


--
Dan Walters