Sum of same/different words

Copper Contributor

Hey guys, 
I´m trying to create my own online logbook but I have a problem.
I want to calculate how many different helicopter I flew. 
For example: 
AAWWE

AAWWE

BBEEZ

BBEEZ

134

Would make a total of 3 Helicopter. How can I do that?
Unfortunately they are not in order like this above.

3 Replies

@Timmy1999 

=COUNTIF($A$1:A1,A1)
=COUNTIF(B1:B7,1)

Maybe with these formulas in cells B1 (filled down to B7 in the example) and C1.

countif.JPG

 

Hey, I already thought about this option.
But I need to add a extra chart for every option of word to count right? thats a bit too much work.

@Timmy1999 

Presuming the data is in A1:A5, you could try:

=COUNTA(UNIQUE(A1:A5))