HOW TO USE COUNTIF BETWEEN SHEETS?

Brandon Morales

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

Hudson_Miller

@Brandon Morales

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

Hud

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!