Hello, I am using an averageif to calculate the average of the prices that a company bought boxes of aluminium. I am using the following function and excel calculates the average price of aluminium buys only (the data is in different page and the function is on another sheet called results)
=AVERAGEIF('SHEET A'!F2:F14;"ALUMINIUM";'SHEET A'!K2:K14)
I am having problem with doing the same thing with min and max function. I want excel to find the minimum and maximum price of aluminium buys only.
I would appreciate the help because this is for my work.
Sincerely yours
Syban
=AVERAGEIF('SHEET A'!F2:F14;"ALUMINIUM";'SHEET A'!K2:K14)
I am having problem with doing the same thing with min and max function. I want excel to find the minimum and maximum price of aluminium buys only.
I would appreciate the help because this is for my work.
Sincerely yours
Syban