I have a going across issue. In sheet 1 as you can see that each code can have either a space or yes when going across. What I need to function that tells me this:
If I enter 2 in [E2] then I see the number 1 in [H2] ….so basically, it returns the count of the occurrences of the string “YES” for a row that you specified in cell E2
How can I do that in VBA? In the quickest speed way?