Need help with COUNTIF referencing another sheet

Edgar1234

Hello, can somebody help identify what is wrong with this formula =COUNTIF({Quasar DFMEA - Data Shuttle RPN Range}, [RPN]:[RPN], I'm getting a "UNPARSEABLE" error.

KPH

It could be that your cross sheet reference is not set up correctly.

You should have one sheet with a text/number column in it that contains the RPN values, like this:

(the column name doesn't matter and you can have lots of other columns as well).

You set up a reference to that sheet like this:

(the entire column is selected and the reference name is the exact one used in the formula)

Then on another sheet you should have a cell in a text/number column with this formula in:

=COUNTIF({Quasar DFMEA - Data Shuttle RPN Range}, >99)

In my example that would give an answer of 3.

Edgar1234

sorry, I meant to say with this formula ==COUNTIF({Quasar DFMEA - Data Shuttle RPN Range}, [RPN]:[RPN], >99)

KPH

Too many conditions in the COUNTIF?

Does this work?

=COUNTIF({Quasar DFMEA - Data Shuttle RPN Range}, >99)

Edgar1234

I tried and it says Invalid Ref. I guess this is missing the "range".

KPH

Hi @Edgar1234

COUNTIF just has two parts, the range (the thing to count) and the criterion to be met to be included in the count.

It looks like your range is a column in another sheet that you have called {Quasar DFMEA - Data Shuttle RPN Range} and you want to count any rows in that range that have a value greater than 99. Is that what you are trying to do?

Edgar1234

Yes KPH. That is exactly what I'm trying to do.

KPH

It could be that your cross sheet reference is not set up correctly.

You should have one sheet with a text/number column in it that contains the RPN values, like this:

(the column name doesn't matter and you can have lots of other columns as well).

You set up a reference to that sheet like this:

(the entire column is selected and the reference name is the exact one used in the formula)

Then on another sheet you should have a cell in a text/number column with this formula in:

=COUNTIF({Quasar DFMEA - Data Shuttle RPN Range}, >99)

In my example that would give an answer of 3.

Edgar1234

Yes. It worked. Thank you so much KPH. :-)

KPH

Great news!