vendredi 6 juillet 2018

AVERAGE using multiple criteria from multiple columns

I need to calculate the average value of a column contain temperature values (column H). The difficult part is that I want to average only specific cells of this column, that meet certain criteria. More specifically, I want to average temperature values from column H, only if the wind direction is northwest,which is detoned as "NW", the values of which are in column J, as well as if the wind speed is lower than 2 (column D). I used the AVERAGEIFS command but I recieve a message that "excel the formula you typed contains an error".

AVERAGEIFS($J$3:$J$5434;"NW";$H$3:$H$5434;D3:D5434;"<2")

Is the averageifs not the proper command to calculate this? Do you have any other ideas on how I could do it?

Aucun commentaire:

Enregistrer un commentaire