How to find text and then divide numbers associated with that text

D

darkwing_duck

I have a spreadsheet that has the revenue a set of clients has
provided in Columns A & B (client name in A, $$ in B). The profit for
that set of clients in Columns D & E (client name in D, $$ in E). Then
I have a subset of those clients in Column G

It looks like this:

Columnt A Column B Column D Column E Column G
Customer Name Revenue Customer Name Profit Customer Name
Customer G 1,300,000 Customer E 13,000 Customer A
Customer F 700,000 Customer G 12,000 Customer C
Customer E 1,200,000 Customer C 11,000 Customer D
Customer D 800,000 Customer A 10,000 Customer G
Customer C 900,000 Customer D 9,000
Customer B 1,100,000 Customer B 8,000
Customer A 1,000,000 Customer F 7,000

I want to create a formula in Column H (next to the customer names in
G) that finds the same name in A and D, and then divides the profit
for each customer into the revenue.

Suggestions?

Thanks,
Robert
 
R

Ron Coderre

Try this:

H2: =SUMIF($A$1:$A$10,G2,$B$1:$B$10)/SUMIF($D$1:$D$10,G2,$E$1:$E$10)

Adjust ranges to suit your situation.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
J

joeu2004

I have a spreadsheet that has the revenue a set of clients has
provided in Columns A & B (client name in A, $$ in B). The profit for
that set of clients in Columns D & E (client name in D, $$ in E). Then
I have a subset of those clients in Column G
[....]
I want to create a formula in Column H (next to the customer names in
G) that finds the same name in A and D, and then divides the profit
for each customer into the revenue.

=vlookup(G2, $A$2:$B$8, 2, false) / vlookup(G2, $D$2:$E$8, 2, false)


----- complete previous posting -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top