Minimum of a certain range

Sarah Bird

Hello,

I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around?

This is my attempt, but it does not work:

=MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))

Genevieve P.

Hi @Sarah Bird

Since you're using a cross-sheet reference/formula, you won't be able to use the IF function in this way.

Instead, you can use the COLLECT function to collect certain cells based on the criteria in your Region column, then find the MIN of those collected dates.

Try this:

=MIN(COLLECT({Column of Dates Here}, {PM Sheet Region}, "TQM"))

Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi @Sarah Bird

Since you're using a cross-sheet reference/formula, you won't be able to use the IF function in this way.

Instead, you can use the COLLECT function to collect certain cells based on the criteria in your Region column, then find the MIN of those collected dates.

Try this:

=MIN(COLLECT({Column of Dates Here}, {PM Sheet Region}, "TQM"))

Let me know if this works for you!

Cheers,

Genevieve

Sarah Bird

Thank you @Genevieve P! That is just what I needed.