assuming range is A1:a18
Formula:
=COUNTIF(A1:A18,"orange")
or
if you want the whole column
Formula:
=COUNTIF(A:A,"orange")
assuming range is A1:a18
Formula:
=COUNTIF(A1:A18,"orange")
or
if you want the whole column
Formula:
=COUNTIF(A:A,"orange")
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks