Hi there,

I have a column B which will have text appear and want to count how many times it shows

I have the formula =sum(IF( Tally!B6:B80="facebook" 1,0)) and it counts the first entry if facebook but then doesn't count the rest

What I'm I doing wrong ????

Sorry think I have found it while I was writing this

=COUNTIF(Tally!B6:B80,"Facebook")

tried it and it works

## Bookmarks