| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to summarize the first 4 numbers greater than 0 from a list.
I've a list of numbers, I need to summarize the first 4 greater than zero
cronologically eventhough they were in different places, and it could happen only three or less were in the whole list. Ex. 2 0 0 0 8 -3 -5 0 4 0 0 0 3 0 0 0 0 7 8 9 4 5 1 2 -8 -7 Sum. 2 + 8 + 4 + 3 = 17 easy hu? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select specific numbers from a list based on position | Excel Discussion (Misc queries) | |||
| How do I delete a character from a list of item numbers? | Excel Worksheet Functions | |||
| How can I superscript numbers greater than 3? | Excel Discussion (Misc queries) | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| How can I compare a number against a list of numbers | Excel Worksheet Functions | |||
Threaded Mode
