Excel Question regarding formulas
Posted on 2006-07-20
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.