View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DanielWalters6 DanielWalters6 is offline
external usenet poster
 
Posts: 27
Default Running total within IF

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