HOW TO USE COUNTIF BETWEEN SHEETS?

Hi, i have a sheet (pictured below), that has a "machine / equipment" column that corresponds to a second sheet. in my second sheet i would like to use count if to count the number rows that exist where the "machine/equipment are the same or match. below i tried 2 formulas but they wont work. Any ideas??

=COUNTIF({Facilities Work Requests Range 1}, {Facilities Work Requests Range 3}, =[MACHINE / EQUIPMENT]@row)

=COUNTIF({Facilities Work Requests Range 1}, MATCH([MACHINE / EQUIPMENT]1, {Facilities Work Requests Range 3}, 0))

Sheet 2

Sheet 1

Find more posts tagged with

Accepted answers

Hudson_Miller

@Brandon Morales

Why do you need the Match function? Just do a =Countif({Facilities Work Requests Range 1}, [MACHINE / EQUIPMENT]@row)

Hud

All comments

Rob Kightlinger_PCG

Brandon,

You don't need the 0 at the end of the formula. Try this

=COUNTIF({Facilities Work Requests Range 1}, MATCH([MACHINE / EQUIPMENT]1, {Facilities Work Requests Range 3}

Rob Kightlinger

Prime Consulting Group

Brandon Morales

still coming up invalid operation

=COUNTIF({Facilities Work Requests Range 1}, MATCH([MACHINE / EQUIPMENT]1, {Facilities Work Requests Range 3}))

Hudson_Miller

@Brandon Morales

Why do you need the Match function? Just do a =Countif({Facilities Work Requests Range 1}, [MACHINE / EQUIPMENT]@row)

Hud

Brandon Morales

That did the trick- thank you Hudson!

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.