Cannot CountIf from a Formula Column

Leah Brown

Hey everyone,

I have a column that has a vlookup function to produce an out of a region name such as Americas. I want to summarize the count that has Americas as the output in the Sheet Summary tab. However, when I use the countif formula, I receive a No Match even though I know I have regions of Americas. This was working 2 weeks ago so not sure what changed any help would be appreciated.

I have confirmed there are no typos.

Paul Newcome

Can you provide some screenshots of the reference table and the sheet containing the VLOOKUP?

brianv

I'm noticing this issue as well. Column Formula appears to change the data type making AVG(), COUNTIF(), COUNTIFS(), and other sheet summary formulas show "#INVALID DATA TYPE" whether the column formula is numeric or text (I have a column formula that looks for # of days a job req is open and if <30 fills a cell with "Best Athlete". # of days a req is open is also a column formula that counts NETDAYS() from the date the req was opened).

Paul Newcome

@brianv Are you able to provide screenshots and the underlying formulas? I have never had an issue with a column formula converting a numeric output to a text output and can't seem to recreate it.