Average

[sandejos]

Hi ,
Please help what is the formula to find the average between to numbers. e,g I have a one column and i have to find out the average of diff ranges like 0-50 , 51-200, 201-1000,1001-5000

ColumnA
2
50
100
3
101
496
395
35
60
758
892
44
154
79
2000
359
25
1396

Please help
Regards,
Sandeep Joshi

 

[Joe4]

Welcome to the Board!

You should be able to do this with the AVERAGEIFS formula. See: MS Excel: AVERAGEIFS Function (WS)

So, let's say that your data was in the Range A1:A18. To find the average of the values between 0 and 50, your formula would look like this:

=AVERAGEIFS(A1:A18,A1:A18,">=0",A1:A18,"<=50")

Then just repeat for the other ranges, changing the hard-coded values in each formula.