Kwnstantinos_M
New Member
- Joined
- Jun 12, 2018
- Messages
- 24
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:
Is the averageifs not the proper command to calculate this? Do you have any other ideas on how I could do it?
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:
Code:
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?