Forum Discussion

sameergupta60's avatar
sameergupta60
Icon for Helper IV rankHelper IV
5 years ago

Need help

Hi,   I want some help with the below example.   10         22         27         45         155 include Avg:- 29     15 exclude Avg:- 21 range 5 to 45 ...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi sameergupta60 ,

 

I can find that 29 = AVERAGE(A5:A17). But how is "21" calculated?

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.