Excel trickery

[DaveB]

I have an excel spread sheet, part of which contains the answers to a series of Y/N questions.

Is there an easy way to tot up the number of yes's in the range?

This is an example of what I want to get as the end result withut having to add up the yes's in each row by hand.

    A    B  C   D   E   F   G
1 Item   Q1 Q2  Q3 Q4  Q5  Total
2 foo    Y   N  Y   Y   N    3
3 bar    N   N  N   Y   Y    2

[Olly]

=countif

[NiceUpNorth]

OMG basic excel skills.....

[RichardCranium]

Wot's excel?

Is it like 123?

To 'excel' is to invest in a flash car, like an open topped Jag, so that you can pull the hottest totty available (e.g. the lustee) and so be distinguised from the rest of the world by your outstanding notability.

[NickFitz]

Wot's excel?

Is it like 123?

Similar to VisiCalc I believe.

[RichardCranium]

Similar to VisiCalc I believe.

I have a sudden urge to play a game that involves flying a helicopter back and forth and rescuing people.

Found it! Choplifter.

[NickFitz]

Choplifter.

Haven't seen that site before.

I worked on the PC conversion of this one