Excel - how to count cells with data

ray_gillespie

OSNN Veteran Addict
Political Access
Joined
21 Mar 2002
Messages
1,693
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:

A_________________B
Star Wars_________Yes
Godfather_________Yes
Some Like It Hot____
Alien_____________Yes
Gladiator__________Yes

Is there any way of having the last row in the table add up the number of 'yes's?

For example:

A_________________B
Star Wars_________Yes
Godfather_________Yes
Some Like It Hot____
Alien_____________Yes
Gladiator__________Yes
________________4

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.
 

Dark Atheist

OSNN Veteran Addict
Political Access
Joined
8 Apr 2003
Messages
6,376
=SUM(B3:B1037) change the numbers to reflect the start cell and end cell - for example =SUM(B3:B100) - the more you add just change the last part of the sum
 

LeeJend

OSNN Veteran Addict
Joined
25 Jan 2003
Messages
5,291
That doesn't work. Sum only works on numbers.

Use the counta function instead of sum. You could have found this yourself by typing "count entries" in excel help. I'm so sorry to find out both of your arms are broken...

:p
 

ray_gillespie

OSNN Veteran Addict
Political Access
Joined
21 Mar 2002
Messages
1,693
Awesome, got it sorted, thanks.

Arms fully healed now.

:)
 

Members online

No members online now.

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,411
Members
5,591
Latest member
nodee