Novice needing help

[bluetntmo]

I want do do sometime I thing I thing should be quite easy but I cannot work out how to do it

I have asked 57 people a question so I have a column with yes or no against thier names

How do I work out a forula to give me an average??

 

[FormR]

Welcome to the Forum.

Something like this, for example:

Excel Workbook
	A	B	C	D
1	Question			Avg
2	Yes		Yes	62%
3	No		No	38%
4	Yes
5	Yes
6	Yes
7	Yes
8	Yes
9	Yes
10	No
11	No
12	No
13	No
14	Yes
Sheet1

 

[ttdk1]

Suppose you got a list of people's name from A2 to A99. Their response yes or no in B2 to B99. And the average for yes is in D2

=AVERAGE(--(B2:B99="yes"))

use ctrl+shift enter to make that an array formula

 

[bluetntmo]

Thanks FormR I adapted this to suit but why the $ symbols instead of just the range?

 

[bluetntmo]

Thanks ttdk1 I tried that too but all I go was the number 1 (maybe because I don't know what and array formula is)

 

[FormR]

Thanks FormR I adapted this to suit but why the $ symbols instead of just the range?

Great, glad you got it working.

Using $ symbols prevents the ranges from changing as the formula is copied to other cells - see here:
Relative & Absolute Cell References in Excel

 

[ttdk1]

Thanks ttdk1 I tried that too but all I go was the number 1 (maybe because I don't know what and array formula is)

when you input the formula in the formula bar, instead of pressing enter to complete it, you hold down ctrl and shift then press enter instead.