How to Total YTD Income and Commission Per Person From Values at Adjacent Columns? (Tables Fixed Hopefully)
 

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 AMT
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 FROM CLIENT
10 Anna: 100
11 Bobi: 200
12 Casy: 300


15 YTD COMMISSION PAID
16 Zack: 150
17 Yani: 90

How to Total YTD Income and Commission Per Person From Values at Adjacent Columns? (Tables Fixed Hopefully)
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany


Sarah Anderson wrote:
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 AMT
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 FROM CLIENT
10 Anna: 100
11 Bobi: 200
12 Casy: 300


15 YTD COMMISSION PAID
16 Zack: 150
17 Yani: 90

How to Total YTD Income and Commission Per Person From Values at Adjacent Columns? (Tables Fixed Hopefully)
 

On Wed, 19 May 2004 00:16:01 +0200, "Frank Kabel"
wrote:

Hi
see your other post

Thanks Frank!

The instructions were a bit confusing for a newbie but after I tried
it out, I think I got it!

Pivot Tables are really nice!

How to Automatically Correct Formula All the Way Down a Column?
 

I recently changed a formula in the top cell of one of my columns. I
want it to automatically carry the changed formula over to all the
cells under it. Is this possible?

I've been cutting and pasting over and over but this is slow and
pasting mistakes happen. :(

How to Automatically Correct Formula All the Way Down a Column?
 

Another way to copy the revised formula down to the last row --

Select the cell that contains the revised formula
Point to the cell's fill handle (black square at the
bottom right of the cell)
When the pointer changes to a black plus sign, double-click

Sarah Anderson wrote:
I recently changed a formula in the top cell of one of my columns. I
want it to automatically carry the changed formula over to all the
cells under it. Is this possible?

I've been cutting and pasting over and over but this is slow and
pasting mistakes happen. :(


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

How to Automatically Correct Formula All the Way Down a Column?
 

On Wed, 19 May 2004 14:50:43 -0400, Debra Dalgleish
wrote:

Another way to copy the revised formula down to the last row --

Select the cell that contains the revised formula
Point to the cell's fill handle (black square at the
bottom right of the cell)
When the pointer changes to a black plus sign, double-click

Thanks! That's a very nice time saving tip.