Need help with a formula to pull in data with a certain criteria from a column ...

Hey Folks,

Need help with a formula to pull in data with a certain criteria from a column in a Sheet source into a Metric Sheet.

I'm wanting to only pull in a summary of 2 or more ( 2 = >) Jobs meeting the criteria for any given month. So in the Archive Sheet screenshot below, if rows 294 through 305 were January for Line 3, the formula would show 3 Jobs for the Month in the Metrics Sheet for the criteria that was met as opposed to Line 2 only showing one instance and thus 0 instances for criteria having been met.

See 2 Screenshots below and thanks.

Vince

screenshot of ARCH Lines and Metrics.jpg

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You would use a COUNTIFS to first get your total count. Then you would wrap that in an IF to say "if the countifs is greater than or equal to two, output the countifs, otherwise output zero".

=IF(COUNTIFS(……………..) >= 2, COUNTIFS(……………….), 0)

VinceA

Thanks Paul … I'm royally screwing up the argument set as I am getting that it is incorrect as I'd also need to reference Monthly Ranges.

……………………………………………………………………….

BTW, I did originally tackle this in a different way but that too didn't work for me which led me here … SEE BELOW:

VinceA

So I'm still playing around with this to no avail. Anyone of our Formula Elites have any thoughts.

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.