Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
How to Total YTD Income Per Client and YTD Commission Paid Out From Adjacent Columns?
Hi everyone. I hope you can help me out here. Pretty Please. :)
My manager asked me to use Excel to (1) total the YTD income for each client and to (2) total the YTD commission paid out to each person earning commission from an ongoing data table that is updated weekly. Question: What formulas do I use to automatically find the total year to date (YTD) income comming from clients: Anna, Bobi, and Casy. Similarly, what formulas do I use to automatically find the total year to date (YTD) commission paid to Zack and Yani? Since the income and commission amount is on a adjacent column, will this be difficult? Please reply in the ng. Thanks. The table below contains the income and commission data (updated weekly): Table: A B C D 1 Client Name Income From Client Commission Paid To Commission Amount 2 Anna 25 Zack 10 3 Bobi 50 Zack 20 4 Bobi 150 Yani 60 5 Anna 75 Yani 30 6 Casy 300 Zack 120 I need these following results to show up under the table above: A B 9 YTD Income From Client 10 Anna: 100 11 Bobi: 200 12 Casy: 300 15 YTD Commission Paid 16 Zack: 150 17 Yani: 90 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you total columns that are not adjacent | Excel Worksheet Functions | |||
Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
Function returning the total of two adjacent columns | Excel Worksheet Functions | |||
chart: mileage MPG Fuel total paid | Charts and Charting in Excel | |||
how do i set uo total income and annual figures in excel? | New Users to Excel |