jbolduc123
New Member
- Joined
- Mar 22, 2018
- Messages
- 3
Hi,
I hope this makes sense..... I'm trying to calculate the median of salaries that meet a set of criteria. I've looked at other threads, and tried the {=Median(if(A1:A16=criteria,B1:B16))}. This formula works, but it's not returning the median I'm looking for.
For example, I want to find the separate Median Base Salary of all positions titled Position #1 , all the positions titled Position #2 , Position #3 , etc. (in the table below), without having to manually select the range in column B. Any and all help is greatly appreciated.
<tbody>
</tbody>
I hope this makes sense..... I'm trying to calculate the median of salaries that meet a set of criteria. I've looked at other threads, and tried the {=Median(if(A1:A16=criteria,B1:B16))}. This formula works, but it's not returning the median I'm looking for.
For example, I want to find the separate Median Base Salary of all positions titled Position #1 , all the positions titled Position #2 , Position #3 , etc. (in the table below), without having to manually select the range in column B. Any and all help is greatly appreciated.
[ColumnA] Position # | [ColumnB] Base Salary | [ColumnC] Median Salary |
Position #1 | $204,750.00 | $204,750.00 |
Position #2 | $155,000.00 | $155,112.00 |
Position #2 | $155,224.00 | $155,112.00 |
Position #3 | $208,464.00 | $208,464.00 |
Position #4 | $175,000.00 | $189,037.50 |
Position #4 | $203,075.00 | $189,037.50 |
Position #5 | $195,209.00 | $199,142.00 |
Position #5 | $203,075.00 | $199,142.00 |
Position #6 | $180,000.00 | $203,075.00 |
Position #6 | $203,075.00 | $203,075.00 |
Position #6 | $231,750.00 | $203,075.00 |
Position #7 | $165,661.00 | $203,075.00 |
Position #7 | $203,075.00 | $203,075.00 |
Position #7 | $230,000.00 | $203,075.00 |
<tbody>
</tbody>