# Probability

#### AmyShann

##### New Member
Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing my mind!! Please! And thankyou in advance ?

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### ParamRay

##### Well-known Member
Can you give some info on how your worksheet is structured, i.e. what are the columns, where is the data, etc?..

#### Kamolga

##### Well-known Member
You need to first split your 3 criterias. Calculate how many females over total people. I would use
Code:
``countif(A1:A99;"Female")/count(A1:A99)``
formula if people sex was in column A, from row 1 to 99. In another cell, calculate how many live in London using the same formula but with London. Third cell would be
Code:
``Countif(C1:C100;">=495")/count(C1:C99)``
if net salaries are in column C. You then multiply each percentage to get the probability it happens. You can calculate everything at once multiply directly but it is good to check each result the first time.

Last edited:

#### AmyShann

##### New Member
Thankyou so much!!! I've been trying to do it all at the same time and it's just not going to work you're a diamond thankyou &#55357;&#56842;

#### Kamolga

##### Well-known Member
You are welcome. Thanks for the feedback.

#### kweaver

##### Well-known Member
Two important things to remember about probability:

1. The probability of an event is a fraction: (#successful ways)/(# total ways)
2. The probability of TWO events both happening is an AND condition which requires multiplying the individual probabilities and
the probability of TWO events where EITHER could happen is an OR condition which requires adding the probabilities.

#### AmyShann

##### New Member
Two important things to remember about probability:

1. The probability of an event is a fraction: (#successful ways)/(# total ways)
2. The probability of TWO events both happening is an AND condition which requires multiplying the individual probabilities and
the probability of TWO events where EITHER could happen is an OR condition which requires adding the probabilities.
Thankyou!!!

1,102,679
Messages
5,488,226
Members
407,632
Latest member
varunwalla

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...