If your sheet1 criteria (apple, orange, pear) are in A1 down and list of
fruits is in sheet2 column A with dollar amounts in sheet2 column B then
use this formula in sheet1 B1 copied down

=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)/MAX(1,COUNTIF(Sheet2!A:A,A1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=561876