Excel Question regarding formulas

I am using the following formula to compute the average of a set of numbers from a column if an associated number is greater then or equal to 4.

I would like to do the same thing but find the Min, Max and Median for Column B.

Column A and B are next to each other so if the number in A is greater than or equal to 4, I take the number next to it in column B and do the computation.

Any help would be appriciated, this stuff gives me a headache sometimes.

The formula I am using for Average of thes number is listed below and works fine.

Thanks,


=SUMIF(A1:A10,">=4",B1:B10)/COUNTIF(A1:A10,">=4")
wvbeanerAsked:
Who is Participating?
 
mwharffCommented:
{=MAX(IF(a1:a10>4,b1:b10,""))}
{=MIN(IF(a1:a10>4,b1:b10,""))}
{=MEDIAN(a1:a10>4,b1:b10,""))}

These are array formulas.  Use Ctrl-Shift-Enter instead of just typing enter.

Hope this helps.

Mike
0
 
wvbeanerAuthor Commented:
Works Beautifully.  

Thanks for the quick response.
0
 
mwharffCommented:
Thanks for the points and the grade.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.