Hi

How is your data laid out? Do you have suppliers and products and prices all
on one sheet? It sounds like a job for either a Pivot Table or maybe
SUMPRODUCT.

Andy.

"willy" wrote in
message ...

Hi
still having trouble working this one out. Someone suggested Sumproduct
but I couldn't get a result. Problem is I'm trying to create an
inventory to compare prices from 10 different suppliers of 200
products. I want to be able to change the prices as they fluctuate and
see the total for each supplier reflect the change ie. the formula
needs to be quantity*price = total of 200 items. I don't need to see
total price for each item, which I know would make the whole thing
easier as I could create a SUM but I end up with twice as many columns.

Any help greatfully received. Thanks

Willy


--
willy
------------------------------------------------------------------------
willy's Profile:
http://www.excelforum.com/member.php...o&userid=32901
View this thread: http://www.excelforum.com/showthread...hreadid=528523