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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,702
Office Version
  1. 365
Platform
  1. Windows
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
 

ttdk1

Board Regular
Joined
May 21, 2014
Messages
189
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
 

bluetntmo

New Member
Joined
Sep 19, 2014
Messages
4
Thanks FormR I adapted this to suit but why the $ symbols instead of just the range?
 

bluetntmo

New Member
Joined
Sep 19, 2014
Messages
4

ADVERTISEMENT

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)
 

ttdk1

Board Regular
Joined
May 21, 2014
Messages
189
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,652
Messages
5,838,597
Members
430,557
Latest member
MK15

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
Top