Quote:
Originally Posted by Pecoflyer
perhaps something like =sumproduct((datedif(c2:c10,today(),"y"),--(b2:b10="m"))/countif(b2:b10,"m")
for men
replace "m" with "f" for women
|
Thank you so much for you reply!
I switched the two parts in sumproduct now it works! thank you and hugs!!!!!!!!!