• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel trickery

DaveB

Nice But Dim
Joined
Oct 29, 2005
Messages
21,124
Likes received
5,496
Thanks received
1,575
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.

Code:
    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
 
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.
 

Advertisers

Back
Top