| 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? |
| 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 | |||
Threaded Mode
