COUNTIFS referencing another sheet

Question

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?

Can you try like this: `=SUMPRODUCT(COUNTIFS(BRIDGE!H2:H500,">50",BRIDGE!H2:H500,"<75" ))`? — Vityata, Feb 13 '17 at 16:24

score 0 · Accepted Answer · answered Feb 13 '17 at 16:29

0

In your formula you do not refer to the "Bridge" tab on the second range of the CountIfS formula. It should be like this:

=SUMPRODUCT(COUNTIFS(BRIDGE!H2:H500,">50",BRIDGE!H2:H500,"<7‌5" ))

answered Feb 13 '17 at 16:29

Vityata

42,633
8
55
100

I think all you need is this: `=COUNTIFS(BRIDGE!H2:H500,">50",BRIDGE!H2:H500,"<7‌5" )` – CallumDA Feb 13 '17 at 16:45

COUNTIFS referencing another sheet

1 Answers1