Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
running total | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
Getting a running total? | Excel Worksheet Functions | |||
Running Total | Excel Worksheet Functions |