MINIF worksheet function

ltdanp22
ltdanp22 used Ask the Experts™
on
I basically want AVERAGEIF but instead of the average, I want the min. Is there a way to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you can use an array formula like= MIN(IF(A1:A100="",A1:A100))confirm the formula by using CTRL + SHIFT + ENTER to get the {} around the formula in the formula barhope this helps.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial