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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509314