J Jeff Apr 5, 2004 #1 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?
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?
F Frank Kabel Apr 5, 2004 #2 Hi Jeff try the array formula (entered with CTRL+sHIFT+ENTER) =AVERAGE(IF(A1:A100="male",B1:B100))
A AlfD Apr 5, 2004 #3 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
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
G Guest Apr 5, 2004 #5 I still need help. The above formula averages the whole column not just the male figures.
F Frank Kabel Apr 5, 2004 #6 Hi the above one should only average males. What is the exact formula you have entered
