This is very simple but too complicated for us. I have a spreadsheet with 12,000 single line client bill entries.
I need you to sum the total for each client and then spit out a list of the clients and the total amount we have billed them.
Spreadsheet data looks like this:
Shai Harary $155.53
Shai Harary $52.53
Shai Harary $26.78
Shai Harary $36.05
Shai Kedem Outlier Entertainment $51.50
Shalonda Cornitcher Passerine $108.15
Shalonda Cornitcher Passerine $1,468.93
Shalonda Cornitcher Passerine $10.30
Shane Collins New Sponge Media $30.90
Shane Collins New Sponge Media $76.22
Shane Collins New Sponge Media $44.29
Shane Richard $233.81
Shane Wright $30.90
Shane Wright $72.10
Shane Wright $103.00
Shannon D. Miller Redd Lionn $158.15
Shannon D. Miller Redd Lionn $103.00
Shannon Goldman $997.04
Shannon Goldman $12.36
What I need to see is:
Name: Total Billed
Shalonda Cornitcher $1587.38
Shanon Goldman $997.04
etc. for all clients and then have them sorted by who is the highest billed on down to lowest. Would like this today. I can send the spreadsheet. Sample sheet is attached.