Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the average using the Lookup function or similar | Excel Discussion (Misc queries) | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
lookup more than one cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |