assuming range is A1:a18

Formula: copy to clipboard
=COUNTIF(A1:A18,"orange")


or

if you want the whole column
Formula: copy to clipboard
=COUNTIF(A:A,"orange")