Have some data I cut and paste from an online database into excel. Trying to use countifs and sumifs. One of the criteria ranges has mixed single and double digit numbers pasted from the online database. My formula works with double digit numbers but not single digit numbers. I had a similar problem with this data in if statement a few months ago and got help from Vlady using the following.
=IF(ISNUMBER(SEARCH(" "&$A$1&" "," "&SUBSTITUTE(A4,CHAR(160),CHAR(32))&" ")),TRUE,FALSE)
I can't figure out how to utilize this same theory in Countifs or sumifs.
My example is attached. Thanks for helping
Bookmarks