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:)
|