Minimum of a certain range

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}))

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.