I'm trying to count the values of cells when the adjacent cell has specific text. So, if column A has randomly repeating names and column B has random numbers 1-10, I'm looking to count the numbers that appear in column B next to each of the names.
So far, I have this, but it's not working:
So, random names appear in column C. M2 has the name that I need to count. N2 has the formula in it. The values to be counted are in column B. Can anyone see where I'm doing this wrong?
Thank you for any help anyone can offer!
Bookmarks