Count

K

Kevin

I have a list of suppliers with dollar amounts across from them in a
different cell. I want to be able to total up the amount per supplier. Can
you count the dollar amount by supplier?

Thank You For Your Help,

Kevin
 
D

Dav

Yes have alook at the sumif function

sumif(supplier range,criteria,dollar range)

If the data was in the range a1:b40

sumif(a$1:a4$0,"supplier1",b$1:b$40)

Regards

Dav
 
B

bpeltzer

If the names are in column A and amounts in B, the total is
=sumif(A:A,"Supplier X",B:B).
You might also consider a Pivot Table; drop the suppliers into the Rows
field and amounts in the data field.
--Bruce
 
Top