Average of directions wind

Originally Posted by protonLeah

I don't have 2010, but that AVERAGE.IF (with the dot) looks funny? Maybe AVERAGEIF (no dot)?

Sorry but in portuguese - 'média.se' (w/ the dot).

Originally Posted by Jakobshavn

See:

http://www.excelforum.com/excel-gene...irections.html

ok but do not found to mean «if wind speed > 0 then calculate average of directions wind».

Originally Posted by daddylonglegs

I think you'll have to use an "array formula" with AVERAGE and IF separately, e.g. for that first average

=AVERAGE(IF(wind_begin:wind_end>0;COS(RADIANS(direc_begin:direc_end))))

do the same for the second average function so the whole thing looks like this:

=DEGREES(ATAN2(AVERAGE(IF(wind_begin:wind_end>0;COS(RADIANS(direc_begin:direc_end))));AVERAGE(IF(wind_begin:wind_end>0;SIN(RADIANS(direc_begin:direc_end))))))

confirmed with CTRL+SHIFT+ENTER

I will work it...

@daddylonglegs: I tested and confirmed true average of direction wind.
Thank you!