J
Jeff
If I have two columns (Gender) (Salary) how would i write
the formulas to get the mean and the average salary of
just the males?
the formulas to get the mean and the average salary of
just the males?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi Jeff
try the array formula (entered with CTRL+sHIFT+ENTER)
=AVERAGE(IF(A1:A100="male",B1:B100))
try the array formula (entered with CTRL+sHIFT+ENTER)
=AVERAGE(IF(A1:A100="male",B1:B100))
A
AlfD
Hi Jeff:
You wrote "average" and "mean" with the appearance that you expect the
to be different.
Did you intend "median" (the middle value) rather than mean?
Al
You wrote "average" and "mean" with the appearance that you expect the
to be different.
Did you intend "median" (the middle value) rather than mean?
Al
G
Guest
Im sorry you are right. I just meant the average
G
Guest
I still need help. The above formula averages the whole
column not just the male figures.
column not just the male figures.
F
Frank Kabel
Hi
the above one should only average males. What is the exact formula you
have entered
the above one should only average males. What is the exact formula you
have entered