how to establish a numerical range for average calculation

Asked

Viewed 184 times

0

I want to calculate the average of a variable with the following formula: =MÉDIASE(M2:M487;">=20 <25";O2:O487) or I want the values of M2 to M487 to be greater than or equal to 20 and smaller than 25.

excel

1 answer

1

Hello!

Use =MÉDIASES. It uses more than one criterion to calculate the average. Your formula would look like this:

=MÉDIASES(O2:O487;M2:M487;">=20";M2:M487;"<25")

Hug!

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.