Novice needing help

bluetntmo

New Member
Joined
Sep 19, 2014
Messages
4
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??
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Welcome to the Forum.

Something like this, for example:

Excel Workbook
ABCD
1QuestionAvg
2YesYes62%
3NoNo38%
4Yes
5Yes
6Yes
7Yes
8Yes
9Yes
10No
11No
12No
13No
14Yes
Sheet1
 
Upvote 0
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

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

use ctrl+shift enter to make that an array formula
 
Upvote 0
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)
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,218,744
Messages
6,144,227
Members
450,531
Latest member
avril18

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top