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
tried it and it works