I have this Excel function I need to translate. What it says is Calculate D3:D103 if for the specific cell the value in column A equals 1.
=AVERAGEIF(D3:D103,A3:A103,1)
The D column contains some medians, varying from 1 to 5 with 2 decimals, whereas A is only 1 or 2 (boy or girl).
I saw something with a SUMIF/COUNTIF, but I have to IF for another column’s value!