Sumproduct

[JMJ]

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.

 

[T. Valko]

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$6)

 

[Pete_UK]

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]

Great! Thanks.

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$6)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Great! Thanks.