software

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


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,quot;supplier1quot;,b$1:b$40)

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=509314If the names are in column A and amounts in B, the total is
=sumif(A:A,quot;Supplier Xquot;,B:B).
You might also consider a Pivot Table; drop the suppliers into the Rows
field and amounts in the data field.
--Bruce

quot;Kevinquot; wrote:

gt; I have a list of suppliers with dollar amounts across from them in a
gt; different cell. I want to be able to total up the amount per supplier. Can
gt; you count the dollar amount by supplier?
gt;
gt; Thank You For Your Help,
gt;
gt; Kevin