I have a spread to sumif. Same formula just different team names. Some work but some don't. I can't seem to figure it out. I would truly appreciate any advice.
I have a spread to sumif. Same formula just different team names. Some work but some don't. I can't seem to figure it out. I would truly appreciate any advice.
Remember that when Excel (and most other programming languages) compares text to see if it is equal, it is checking to see if it is equal in every character. Testing on the Cleveland entry in B12, I notice that LEN(B12) and LEN(G12) give different responses (suggesting a difference of some kind between the two cells). Checking CODE(MID(cell,number,1)) for each character shows a trailing space 32 character in B12.
It would seem that you will need to go through and clean up your data to make sure there are no leading/trailing spaces and other non-printing characters. TRIM() and CLEAN() functions can be useful here (though be aware that they don't work on non-breaking space 160 characters).
Originally Posted by shg
Best is to clean up your data as suggested by MrShorty, else just add &"*" to your criteria:
=SUMIF($G$5:$G$69,$B5&"*",$K$5:$K$69)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks