COUNTIFS Formula in Sheet Summary Returning "#NO MATCH"
Hi all,
I had a formula in place yesterday that was working fine, but this morning is returning no match. In our sheet summary, I am trying to count the number of quarantined individuals in a specific market. Here is the formula I was using:
=COUNTIFS(Market1:Market1832, ="NE/IA", Quarantined1:Quarantined1832, <>"")
The markets are filled with a VLOOKUP. My confusion is that it was working yesterday, but is not today. If anypne has any feedback, I would appreciate it.
Thanks
Best Answer
-
I managed to track down the issue, I think. One of the lines in my reference sheet was changed and one of the cells in the column I was running the formula on was now a #NO MATCH. When I corrected this, the entire formula began to work again. I think that if there is an error in the column you are trying to count, the formula returns the same error.
That's my theory, anyway, but I got it working again. Thank you anyway!
Answers
-
Hi Jennifer,
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I managed to track down the issue, I think. One of the lines in my reference sheet was changed and one of the cells in the column I was running the formula on was now a #NO MATCH. When I corrected this, the entire formula began to work again. I think that if there is an error in the column you are trying to count, the formula returns the same error.
That's my theory, anyway, but I got it working again. Thank you anyway!
-
Excellent!
Happy to help!
Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you so much for posting this as an answer to this. Because I was about to pull my hair out as to why my formulas weren't working - a Google search for something like "#NO MATCH not working formula Smartsheet" led me here. I found the #NO MATCH cells and fixed the error (it was also a VLOOKUP formula within those cells, like yours) - and voila, my COUNTIFS formulas have been fixed.
Thanks again! 👍
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives