Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
I have a list of clients in A1:A30
Then in Column B Column C Column D Client's Name #Hrs $/Hr 1 Client1 5 100 2 Client 2 2 200 3 Client 3 1 50 4 Client 1 3 200 5 Client 3 1 100 I need to multiply Column C and Column D to get the total for the row, for the client and then sum the results, by client. Could any one please give me a light on how to do this? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Make a list of the unique clients in a range of cells, say, G2:G4 -
Client1, Client2, Client3 Enter this formula in F2 and copy down as needed: =SUMPRODUCT(--(B$2:B$6=G2),C$2:C$6,D$2:D$6) -- Biff Microsoft Excel MVP "JMJ" wrote in message ... I have a list of clients in A1:A30 Then in Column B Column C Column D Client's Name #Hrs $/Hr 1 Client1 5 100 2 Client 2 2 200 3 Client 3 1 50 4 Client 1 3 200 5 Client 3 1 100 I need to multiply Column C and Column D to get the total for the row, for the client and then sum the results, by client. Could any one please give me a light on how to do this? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Insert a new column B. In column F use this formula:
=E2*D2 and copy down. Then, assuming your list of clients from A1:A30 is unique (no duplicates), put this in B1: =SUMIF(C$2:C$6,A1,F$2:F$7) and copy this down to B30. Hope this helps. Pete "JMJ" wrote in message ... I have a list of clients in A1:A30 Then in Column B Column C Column D Client's Name #Hrs $/Hr 1 Client1 5 100 2 Client 2 2 200 3 Client 3 1 50 4 Client 1 3 200 5 Client 3 1 100 I need to multiply Column C and Column D to get the total for the row, for the client and then sum the results, by client. Could any one please give me a light on how to do this? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Great! Thanks. "T. Valko" wrote: Make a list of the unique clients in a range of cells, say, G2:G4 - Client1, Client2, Client3 Enter this formula in F2 and copy down as needed: =SUMPRODUCT(--(B$2:B$6=G2),C$2:C$6,D$2:D$6) -- Biff Microsoft Excel MVP "JMJ" wrote in message ... I have a list of clients in A1:A30 Then in Column B Column C Column D Client's Name #Hrs $/Hr 1 Client1 5 100 2 Client 2 2 200 3 Client 3 1 50 4 Client 1 3 200 5 Client 3 1 100 I need to multiply Column C and Column D to get the total for the row, for the client and then sum the results, by client. Could any one please give me a light on how to do this? Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
You're welcome!
-- Biff Microsoft Excel MVP "JMJ" wrote in message ... Great! Thanks. "T. Valko" wrote: Make a list of the unique clients in a range of cells, say, G2:G4 - Client1, Client2, Client3 Enter this formula in F2 and copy down as needed: =SUMPRODUCT(--(B$2:B$6=G2),C$2:C$6,D$2:D$6) -- Biff Microsoft Excel MVP "JMJ" wrote in message ... I have a list of clients in A1:A30 Then in Column B Column C Column D Client's Name #Hrs $/Hr 1 Client1 5 100 2 Client 2 2 200 3 Client 3 1 50 4 Client 1 3 200 5 Client 3 1 100 I need to multiply Column C and Column D to get the total for the row, for the client and then sum the results, by client. Could any one please give me a light on how to do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
If and Sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct? | Excel Discussion (Misc queries) | |||
Like Sumproduct, But Different | Excel Worksheet Functions |