| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding numbers from a list over a specific value
This should be rather simple, but I'm not getting it. I have a list of 15
numbers, six of whom are over 10. For the numbers over ten, I need to add the difference between those numbers and 10. For instance, it my list had 12, 11, 13, and 10, I would need excel to add 2+1+3 in a manner where I would not need to add an additional column or row, just entering a formula in a single cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find sum in list of of numbers | Excel Worksheet Functions | |||
| find sum in list of of numbers | Excel Worksheet Functions | |||
| How do I filter a number list by numbers to the right of the decim | Excel Worksheet Functions | |||
| making a list of numbers. | Excel Discussion (Misc queries) | |||
| I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
Threaded Mode
