Helo,
I have (a hope) a simple question.
In Column A i have values say 1,2,4,6,7 etc
In column B I also have random values.
In cell c1 i have a lower limit say 4
in cell d1 i have an upper limit say 9
I want the min, max and average of column B based on the criteria
given in the cell c1&d2.
So in this case if the value in column a is between 4 and 9 i want to have
the min, max or average of column b. (if a2 and a6 are within the range i want the min/max or average of b2 and b6)
Thanks
Bron
I have (a hope) a simple question.
In Column A i have values say 1,2,4,6,7 etc
In column B I also have random values.
In cell c1 i have a lower limit say 4
in cell d1 i have an upper limit say 9
I want the min, max and average of column B based on the criteria
given in the cell c1&d2.
So in this case if the value in column a is between 4 and 9 i want to have
the min, max or average of column b. (if a2 and a6 are within the range i want the min/max or average of b2 and b6)
Thanks
Bron