hi everyone,
im trying to average age (D:D) for individuals who are male (C:C) and in a certain group (B:B).
so far i isolated the males of a certain group by typing in
=SUMPRODUCT((C:C="male")*(B:B="case")) but now i am interested in averaging this isolated population's age.
i was thinking =AVERAGE(IF((SUMPRODUCT((C:C="male")*(B:B="case")),D:D) but it doesnt seem to work. what am i doing wrong here?![]()
Bookmarks