Hi guys, I've got an excel spreadsheet which lists the Channel 4 Top 100 films in column A, alongside a "yes" or a blank cell in column B to indicate whether I have seen the film. For example: Is there any way of having the last row in the table add up the number of 'yes's? For example: Basisally, the formula needs to check each cell for the word "yes" or even just having data present (as I'm not using a "No", just leaving it blank when I've not seen the film) and then count up how many it is. Any help will be much appreciated and result it reps flying your way! Thanks.