Question

can someone please tell me what is an alternative function rather than MINIFS?

=MINIFS(G5:G57,D5:D57,"Bed")

Maybe MIN(IF... or INDEX(....,MATCH(MIN

Answer 1

Hello Student,

As we know that MINIFS() function in Excel is used to calculate the minimum within an if statement.

Yes, MIN(IF()) is an alternative function to MINIFS.

Explanation -

MIN(IF()) is an imitation of MINIFS function using ARRAY formula and does the same job.

The INDEX() function shows the value present at given position.

The MATCH() function is used to discover the location of a lookup value in a given column or row.

Example –

The MINIFS formula given in question can be written in MIN(IF()) as:

Format of MINIFS() is:

= MINIFS(minimum range, conditions range, condition)   

= MINIFS(G5:G57,D5:D57,"Bed")                                

We have:

Minimum range as G5:G57

Condition range as D5:D57

And Condition as “Bed”

Format of MIN(IF()) is

= MIN(IF(conditions range = condition, minimum range))

Thus, on arranging the values we get the formula as:

=MIN(IF(D5:D57="Bed", G5:G57))

------------------------------------------------------------------------------------------------------------

NOTE --

You need to press Ctrl + Shift + Enter after entering the MIN(IF()) formula to make the formula work as it is ARRAY formula.

--------------------------------------------------------------------------------------------------------------

THANK YOU!

LIKE THE ANSWER IF IT HELPED YOU