Hi everyone. I've a spreadsheet with one column (eg. A1:a100)
containing a range of values (ages) and another column (B1:100) a value
of either 1 or 2 (representing males vs females).

How can a find the average of the cells A1:A100 that have a value of 1
in column B; ie. the average age of the males only.

Thanks