Mitank Dasondhi
Mitank Dasondhi

Reputation: 23

formula in google sheet to count number of different objects?

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)

How do i do that?

Upvotes: 2

Views: 91

Answers (2)

player0
player0

Reputation: 1

use:

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

Upvotes: 1

JPV
JPV

Reputation: 27312

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

Upvotes: 2

Related Questions