Excel help

PaulStat · 21 Nov 2008 at 15:55

I'm rubbish at Excel, I basically have a list of names of people who can attend an event, marked with a Y or an N depending upon their availability. At the bottom of the column I want to tot up the number of Y's so something like

if(cell=="Y") count++

Is this possible in excel? If so how?

Participant · 21 Nov 2008 at 15:56

=countif(A:A,"Y")

where column A has the "Y"s or the "N"s.

N9ne · 21 Nov 2008 at 15:57

Hidden column to the right of your table with =IF(A1 == 'Y', 1, 0)

Then sum the column at the bottom.

Edit: Robbie G above has a more eloquent solution.

PaulStat · 21 Nov 2008 at 16:01

Robbie G said:
=countif(A:A,"Y")

where column A has the "Y"s or the "N"s.

Ah nice and simple, thanks

Morba · 21 Nov 2008 at 16:02

yeah, a few easy ways to do it