Minimum Statement (More Arguments have been specified...)

Here's my Min statement

=MIN(C21,C23,C25,C27,C29,C31,C33,C35,C37,C49,C51,C53,C55,C57,C59,C61,C63,C65,C67,C39,C41,C43,C45,C47,C69,C71,C73,C75,C77,C79)


However i need to add a few more cells, so it looks like this:

=MIN(C21,C23,C25,C27,C29,C31,C33,C35,C37,C49,C51,C53,C55,C57,C59,C61,C63,C65,C67,C39,C41,C43,C45,C47,C69,C71,C73,C75,C77,C79, C81, C93, C95, C97, C99, C101)

But when I do that I get an error that says " More arguments have been specified for this function than are allowed in the current file format"


Does anyone know how to counter this?

And no I cant just drag the min all the way down the column, because I need certain cells, which are every other one.

Here, try this:

=MIN(IF(AND(ISBLANK(C21:C81),MOD(ROW(C22:C82),2)),0,C21:C81),C93,C95,C97,C99,C101)

comfirmed with ctrl+shift+enter

Of course, other part can also be made as first if there's more numbers:

=MIN(IF(AND(ISBLANK(C21:C81),MOD(ROW(C22:C82),2)),0,C21:C81),IF(AND(ISBLANK(C91:C101),MOD(ROW(C92:C102),2)),0,C91:C101))

comfirmed with ctrl+shift+enter

but if there's no number that can effect your result you can extend first solution from 81 to 101 (adjust all values respectively).

Try:

=MIN(IF($B$21:$B$102="Lawn",IF(E$21:E$102<>"",E$21:E$102)))


confirmed with CTRL+SHIFT+ENTER not just ENTER and copy left or right

Originally Posted by Tommy1005

I tried that NBVC, but it didn't work

Remember that after you enter the formula in, you must hold the CTRL and SHIFT keys down and press ENTER. You will see { } brackets evelop your formula... it is a special array formula.

NBVC's approach is the one I'd recommend but just on the specifics of your original question, you can get MIN to accept more than 30 cells if you bracket some as a "union" (that counts as a single argument), e.g.

=MIN((C21,C23,C25,C27,C29,C31,C33,C35,C37,C49,C51,C53,C55,C57,C59,C61,C63,C65,C67,C39,C41,C43,C45, C47,C69,C71,C73,C75,C77,C79,C81,C93,C95,C97,C99,C101))

Note the extra set of brackets

Please can you start a new thread with your specific query, thanks

Some more specifics would also help, e.g. which formula gave you that error?