Count based on criteria

[schnett]

How does one count as total based on criteria ?

For example :

INPUT :
A1 B1
2 Apple
3 Pear
1 Pear
2 Orange

OUTPUT :
C1 (PEAR) = 4
D1 (Apple) = 2
E1 (Orange) = 2

This maybe an easy function. But I couldn't find it.

Thanx, John

[duane]

see SUMIF function