Jasmine2006
New Member
- Joined
- Oct 9, 2006
- Messages
- 3
I have 16,000+ rows in my spreadsheet, and over 100 names in column A. I need the total in column C to be cumulative at that point, not in total. For example, Anne at row 3 column C is 40 and not 60. If I sorted by A and B, smallest to largest, column C should be 20. Please help! Thank you!
A B C
Name $ Tot$
Anne 40 40
Stan 20 20
King 60 60
Pete 50 50
King -10 50
Anne 20 60
Stan 14 24
Pete -20 30
I have already used the names as set ranges and INDIRECT references everywhere.
A B C
Name $ Tot$
Anne 40 40
Stan 20 20
King 60 60
Pete 50 50
King -10 50
Anne 20 60
Stan 14 24
Pete -20 30
I have already used the names as set ranges and INDIRECT references everywhere.