Average between two values

[cucaracha]

Dear all,

I am using Excel 2003 and I need some help.

I have two columns with wind speed and power

Wind Power
3,50 70,88
5,20 244,27
4,90 199,82
5,00 216,68
4,70 186,12
6,30 387,83
3,90 124,93
5,20 251,70
5,30 279,72
6,00 389,88
6,10 388,77
7,40 652,09
5,90 345,40
6,30 376,61
6,20 399,42
7,10 486,68
6,30 403,35
6,00 382,84
6,40 382,74
7,40 534,23
7,50 593,22
6,30 465,20
5,70 351,60
6,70 503,84
7,00 550,31
6,50 448,34
5,60 312,22

I trying to find a formula to calculate the average of power between wind speeds greater then 4 and less the 6.

After several attempts with array formula no success.


Any help will be appreciated.

Best regards,
Cucaracha

 

[Aladin Akyurek]

Dear all,

I am using Excel 2003 and I need some help.

I have two columns with wind speed and power

Wind Power
3,50 70,88
5,20 244,27
4,90 199,82
5,00 216,68
4,70 186,12
6,30 387,83
3,90 124,93
5,20 251,70
5,30 279,72
6,00 389,88
6,10 388,77
7,40 652,09
5,90 345,40
6,30 376,61
6,20 399,42
7,10 486,68
6,30 403,35
6,00 382,84
6,40 382,74
7,40 534,23
7,50 593,22
6,30 465,20
5,70 351,60
6,70 503,84
7,00 550,31
6,50 448,34
5,60 312,22

I trying to find a formula to calculate the average of power between wind speeds greater then 4 and less the 6.

After several attempts with array formula no success.


Any help will be appreciated.

Best regards,
Cucaracha

E2: 4
F2: 6

G2, control+shift+enter, not just enter:

=AVERAGE(IF($A$2:$A$100>=E2,IF($A$2:$A$100<=F2,$B$2:$B$100)))

 

[T. Valko]

Dear all,

I am using Excel 2003 and I need some help.

I have two columns with wind speed and power

Wind Power
3,50 70,88
5,20 244,27
4,90 199,82
5,00 216,68
4,70 186,12
6,30 387,83
3,90 124,93
5,20 251,70
5,30 279,72
6,00 389,88
6,10 388,77
7,40 652,09
5,90 345,40
6,30 376,61
6,20 399,42
7,10 486,68
6,30 403,35
6,00 382,84
6,40 382,74
7,40 534,23
7,50 593,22
6,30 465,20
5,70 351,60
6,70 503,84
7,00 550,31
6,50 448,34
5,60 312,22

I trying to find a formula to calculate the average of power between wind speeds greater then 4 and less the 6.

After several attempts with array formula no success.


Any help will be appreciated.

Best regards,
Cucaracha

What version of Excel are you using?

 

[cucaracha]

Dear both,

Works like charm

Thank you.

Best regards,
Cucaracha

 

[T. Valko]

I am using Excel 2003 and I need some help.

What version of Excel are you using?

I guess I should be paying closer attention!

 

[Aladin Akyurek]

Dear both,

Works like charm

Thank you.

Best regards,
Cucaracha

You are welcome. Thanks for providing feedback.