paulcraigdainty
Registered User.
- Local time
- Today, 06:00
- Joined
- Sep 25, 2004
- Messages
- 74
I want Excel to add up at set of values that correspond to someone’s name. The number of values can vary. The following is how my data looks in Excel:
Dave 25
Dave 30
Dave 42
Paul 35
Dave 9
Paul 44
Paul 78
Dave 4
Dave 21
I want to use some kind of lookup (not sure if I could tailor vlookup to suit this) to add up all values for Dave and all values for Paul and display as follows:
Dave 131
Paul 157
Does anyone know if this is possible and how I might go about achieving this??
Dave 25
Dave 30
Dave 42
Paul 35
Dave 9
Paul 44
Paul 78
Dave 4
Dave 21
I want to use some kind of lookup (not sure if I could tailor vlookup to suit this) to add up all values for Dave and all values for Paul and display as follows:
Dave 131
Paul 157
Does anyone know if this is possible and how I might go about achieving this??