=SUMIF($A$2:$A$126,"Apples",$B$2:$B$126)

Where a2:a126 is your range of categories, b2:b126 is your range of
sales

apples can be replace by a cell containing apples and the formula can
be copied down if the other categories are below

regards

Dav


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