COUNTIFS Formula in Sheet Summary Returning "#NO MATCH"
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.