wvbeaner
asked on
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")
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the points and the grade.
ASKER
Thanks for the quick response.