how to establish a numeric interval for averaging

Question

Navigation

#1 by (1 votes)

0

I want to calculate the mean of a variable with the following formula: = MEASURE (M2: M487; "> = 20

excel

asked by anonymous 04.09.2016 / 00:10

1 answer

score 1 · Answer 1

1

Hello

Use o = AVERAGE. 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")

Hugs!

15.09.2016 / 19:00