I am using a formula like this in multiple cells and it appears to be working correctly for every other reference except in this case. I am not sure if it is because the cells I am referencing includes parenthesizes in the text.
=COUNTIFS('Cases Completed'!K:K,[@[Case Type]],'Cases Completed'!J:J,$Q$20)+COUNTIFS('Cases Completed'!K:K,[@[Case Type]],'Cases Completed'!J:J,$Q$21)
Q20 = FD – Failed to reject/eject (Cash in Check Acceptor)
Q21 = FD – FD/PF – Failed to reject/eject (Check Failed Business Rule)
Is it because of the ( ) that my result is coming back 0 even though I do have valid data that meets these criteria? Any advice of how I can accomplish this?
Bookmarks