Here's the table I'll be playing with http://img133.imageshack.us/img133/461/helpmekq8.jpg

Now, imagine the data inputted is random, I don't know if a persons name will appear more than once, or maybe even 3 or 4 times... what I need is to get the 3rd column (Total) to somehow =IF there are more than one person, add them together, otherwise, just display their singular total.


My heads spinning... did that make sense?


Thanks for your help!!!!