COUNTIFS referencing another sheet

Vote count: 0

My Fourmula: =SUMPRODUCT(COUNTIFS(BRIDGE!H2:H500,">50",H2:H500,"<75" ))

Trying to count values greater than 50 but less than 75 on another sheet named "Bridge". The problem, this is just counting on the sheet the formula is on, not the referenced sheet. What am I doing wrong?

asked 44 secs ago

westman2222

Let's block ads! (Why?)

COUNTIFS referencing another sheet