I'm trying to create a code to see if my predictions for games and the actual result of the games are the same. I was going to create a point value, like March Madness has, but I can't actually get Google Sheets to count if two cells have the same text. I have tried formulas like: =countif(B14:B15, ""& N14:N15 &"") or =countif(B14:B29, "" & N14:N29 & "") =sumproduct(--EXACT(H18,N18)) =Countif(B18:b19,=N18:n19)
I've tried all these formulas, testing them with both matching and non-matching texts just to make sure that it works, but I either get an error or a constant 1 or 0 regardless of what is true or false. I plan on getting a value, then hiding the row and using those values to multiply the total later, but can't seem to get any formula to work with matching the text between two different cells. I've looked at other people with similar issues, but nothing I've tried works.
If there's something I'm missing, please let me know! Thank you