Counting the results of and Index match not functioning...

Hello,

Has any ever run into an issue where you are using an index match or VLookup to retrieve text, lets say the category for a row and then you want to count how many rows are assigned to that category. Index(Match) formula is working great. But when I build the Countif in the summary field I get #No Match for all of them when I can plainly see them in the column. I even copied the result of the column into the formula to make sure I had the Value correct in the formula. No luck.

If I paste the values into the next column(one for testing purposes) and use the Countif to look at that range it works.

I have Counted the results of Index( Match) columns plenty of times and can not figure out what is different in this case.

Has anyone run into this? and what did you do to remedy it?


Thanks,


Robert Meisch

Deployment Operations Manager & Smartsheet Success team

Sysco

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!