G
Guest
If I have two seperate columns (Gender) (salary), How do
I just get the average salary of just females?
I just get the average salary of just females?
F
Frank Kabel
Hi
you already received answers for getting the average for males
Just replace the value for this condition
you already received answers for getting the average for males
Just replace the value for this condition
B
Bob Phillips
=SUMIF(A1:A100,"Female",B1:B100)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)