I am stumped! I want to thank you in advance for any help you can provide. Document example is attached.
I highlighted in yellow where I am trying to write a formula. I want the formula to search the columns and find the column with the associted name then count the number of cells with Xs and the number of cells without Xs.
Is there a formula that would do this?! Im stumped. I have tried multiple countifs without luck.
Bookmarks