PraveshG81
New member
- Joined
- Oct 6, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
Hello,
I want to find out the Average, Median Max and Min of the "Note Size" (Column B) if the Enterprise Value (Column A) is within the following range:
All Sizes
<$25M
>$25M - <=$100M
>$100M - <=$250M
>$250M - <=$750M
>$750M?View attachment Excel Question.XLSX
i tried doing the MEDIAN(IF(A2:A1000<25000000,B2:B1000) as an array but I numbers don't look right.
I have attached the file for your to look at (two tabs), please let me know what I am doing wrong.
Thank You!
I want to find out the Average, Median Max and Min of the "Note Size" (Column B) if the Enterprise Value (Column A) is within the following range:
All Sizes
<$25M
>$25M - <=$100M
>$100M - <=$250M
>$250M - <=$750M
>$750M?View attachment Excel Question.XLSX
i tried doing the MEDIAN(IF(A2:A1000<25000000,B2:B1000) as an array but I numbers don't look right.
I have attached the file for your to look at (two tabs), please let me know what I am doing wrong.
Thank You!