| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate minus figures
Can anyone help me to calculate the minus figures only in a range of random
costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00 these figures are random as per data entry to hours and cost etc. the figures are to show a loss in costs that could have been saved. i am using excell in office 2000. any help graciously appreciated. Thanks, Nigel |
|
#2
|
|||
|
|||
|
Instead of something like sum(A1:10), use sumif(A1:A10,"<0") and should just
sum those numbers less than zero. "Nigel" wrote: Can anyone help me to calculate the minus figures only in a range of random costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00 these figures are random as per data entry to hours and cost etc. the figures are to show a loss in costs that could have been saved. i am using excell in office 2000. any help graciously appreciated. Thanks, Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate minus figures only | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
| Add up Plus & Minus Figures separately by Location | Excel Worksheet Functions | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Linear Mode
