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?
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!
=MEDIAN(IF((Results!A2:A1000 < 25000000) * ISNUMBER(Results!B2:B1000), Results!B2:B1000))
Last edited by shg; 05-10-2012 at 08:17 PM.
Entia non sunt multiplicanda sine necessitate
hello
good am.
can you check your cell formatting
you used #0.00% for the table
then used percent 1 decimal point for you ave,min,max....
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks