i want to write a formula to get the sum from 1 column from text(names) from another column ex
A B
tom 45.00
tom 16.00
tom 30.00
pete 100.00
pete 75.00
i want to get the sum from tom column B then get the sum from pete etc. i have about 30 names and i would like to write one formula without having to manually scroll and change the range..it seems simple but can't figure it out....thanx
Bookmarks