Lookup, Sum or Calculate
 

Have a spreadsheet with users and their commissions. Would like to create a
function to find all commissions for each user in one column and calculate a
total commission for that user. looks like this

Data Calculated Fields
User Comm User Comm Tot
ABC001 250 ABC001 550
ABC001 300
BBD000 150 BBD000 825
BBD000 200
BBD000 175
BBD000 300

Do I have to use more that one function?

Lookup, Sum or Calculate
 

You can do this with one formula - SUMIF. Assume your data is in
A2:B50, and your unique list of users is in D2:D10. Put this formula in
E2:

=SUMIF(A$2:A$50,D2,B$2:B$50)

and copy down to E10.

Hope this helps.

Pete

Franko wrote:
Have a spreadsheet with users and their commissions. Would like to create a
function to find all commissions for each user in one column and calculate a
total commission for that user. looks like this

Data Calculated Fields
User Comm User Comm Tot
ABC001 250 ABC001 550
ABC001 300
BBD000 150 BBD000 825
BBD000 200
BBD000 175
BBD000 300

Do I have to use more that one function?