formula in google sheet to count number of different objects?

user_15549616 0
Viewed 59

I have a Google spreadsheet with a column that looks like this:

Each cell is dropdown list containing Fruits = [Apple,Orange,Pineapple,Papaya,Cherry,Strawberry]

S.NO | Fruits

  1. Apple

  2. Orange

  3. Pineapple

  4. Papaya

  5. Cherry

  6. Strawberry

  7. Apple

  8. Orange

  9. Cherry

I want to count how many types of fruits are there. (Google sheet formula)

  • Apple, Orange and Cherry occurring twice.

  • There are 6 different types of fruits in column.

How do i do that?

google-sheets count
2 Answers

If I understood correctly and assuming the fruits are in the range A2:A10, you should be able to use

=countunique(A2:A10)

Change range to suit and see if that helps?

REFERENCE

user_38894230

use:

=INDEX(COUNTUNIQUE(LOWER(A1:A)))
user_56326290
Related