Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some formula to add results until a given value is reached?
Hello,
I have a listing of duplicate entries, each with seperate values attached. This list is about 23000 rows long, so obviously I dont want to do this by hand:) What I would like to do is add all of the values together for each set of unique entries. For instance: Bear - 3 Deer - 2 Shark -1 Shark - 2 Shark - 3 Mouse - 4 In this case I would like to know the result of the sum of all Sharks (1+2+3) and then stop the sum once it turned to Mouse. Thanks:) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some formula to add results until a given value is reached?
Consider using a Pivot Table. It can give you the sum of values for each
unique entry. The entries don't even have to be in order. -- Gary's Student "S Davis" wrote: Hello, I have a listing of duplicate entries, each with seperate values attached. This list is about 23000 rows long, so obviously I dont want to do this by hand:) What I would like to do is add all of the values together for each set of unique entries. For instance: Bear - 3 Deer - 2 Shark -1 Shark - 2 Shark - 3 Mouse - 4 In this case I would like to know the result of the sum of all Sharks (1+2+3) and then stop the sum once it turned to Mouse. Thanks:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
How do I delete the formula but keep the results | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |