Help!

Lookup or if statement questoin

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) RSS
Next:  changing the date format - help 2  
Author Message
nerd



Joined: Jul 29, 2008
Posts: 1



PostPosted: Tue Jul 29, 2008 5:01 pm    Post subject: Lookup or if statement questoin


If I have data that looks like this

Bob 5
Sarah 6
Bob 7
Sarah 9
leslie 8

Is there a function that I can use that will esentially add up all of bob, then sarah, then leslie? then if I change the name Bob to Leslie it will automatically change the summation of bob

So it looke like

Bob 12
Sarah 15
Leslie 8
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Excel General (archive) All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum