COUNTIF(A1:A3,"apple")
SUMIF(A1:A3,"apple",B1:B3)


"Tyrone Lopez" wrote:


Is there a formula to count the number of items in a list and its
corresponding sum value, eg

Item $
apple 1.00
apple 2.00
orange 1.50

For the above, the result should be apple=2 items, totalling $3.00.
Orange+ ! item totalling $1.50. :)


--
Tyrone Lopez
------------------------------------------------------------------------
Tyrone Lopez's Profile: http://www.excelforum.com/member.php...o&userid=22194
View this thread: http://www.excelforum.com/showthread...hreadid=544540