Countif help where range column contains column formula and text

Genevieve P.

Thank you for this information!

OK, so the only formula listed above that could produce a #NoMatch error would be the VLOOKUP.

Is is possible that there's a hidden row or collapsed child row that has this error?

Can you try adding the IFERROR around the Project Type formula to see if this resolves your initial COUNTIF formula?

Try this:

=IFERROR(VLOOKUP([Innovation Type]@row, {GPN Dashboard Look-up Table Range 1}, 2, false), "No Match")

Alexis Kipping

Changing Project Type to the formula you suggested worked!

=IFERROR(VLOOKUP([Innovation Type]@row, {GPN Dashboard Look-up Table Range 1}, 2, false), "No Match")

Summary Formula for Active project count is now working :)

Thank you all!!!

Genevieve P.

No problem! I'm glad we could get to the bottom of it and find the root cause. The domino effect with formula errors can be a tricky one to identify! 🙂