AVERAGE using multiple criteria from multiple columns

[Kwnstantinos_M]

Hello

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".

The formula I typed is:

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?

 

[AhoyNC]

In the AVERAGEIFS function the first argument needs to be the range you want to average.
Try:

[TABLE]
<colgroup><col width="501"></colgroup><tbody>[TR]
   [TD="width: 501"]AVERAGEIFS($H$3:$H$5434;$J$3:$J$5434;"NW";D3:D5434;"<2")
[/TD]
 [/TR]
</tbody>[/TABLE]

 

[Kwnstantinos_M]

You are the best! THank you very much!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.