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.