=SUMIF(A:A,"Apple",B:B)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kestrel" wrote in
message ...

Hi,

My brains gone blank... I want to combine a lookup with a sum
function.

A B
Apple 22
Pear 40
Orange 35
Apple 10
Peach 14


So say I wanted the total amount of 'Apple' from column B (which in
this case would be 32).

Thanks

Kestrel


--
kestrel
------------------------------------------------------------------------
kestrel's Profile:
http://www.excelforum.com/member.php...o&userid=19082
View this thread: http://www.excelforum.com/showthread...hreadid=553552