Is there any way to use the MINIFS formula in numbers?

make the first row a header row

C2=IF(A2="", B2, "")

this is shorthand for... select cell C2, then type (or copy and paste from here) the formula:

=IF(A2="", B2, "")

to fill down, select cell C2, copy

select cells C2 thru the end of column C (or as needed), paste

C1=min(C)

Numbers does not support MINIF, MINIFS,MAXIF or MAXIFS.

You could, however extract the values meeting the condition(s) to a new column, then use MIN to get the minimum value fitting the condition(s):

Example:

Columns A and B contain entered data.

C2: IF(A="dog",B,"")

Fill down to all cells in column C

Returns the mass if the pet is identified as a dog. Returns a null string (ignored by MIN() ) if the pet is not identified as a dog.

D2: MIN(C)

Returns minimum numeric value from column C. Ignores all text values.

Regards,

Barry

EDIT: Essentially the same solution as proposed by Wayne. I really should scroll to the end of the thread before responding. 😊

B

in column 3 add a function that includes the value in column 2 when the value in column matches the criteria.

then use the min() function on column 3

If you provide more specifics I can be more specific.