View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franko Franko is offline
external usenet poster
 
Posts: 7
Default 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?