Wondering if there are any non-array formulaes in Excel; I have used Sumif function and countif function to get averages.
are there MaxIF and MinIF ?

thanks


Quote Originally Posted by xld
=MIN(IF(A1:A100="A&quot,B1:B100)

etc.

which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter.Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually.When editing the formula, it must again be array-entered.