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.
|