I have multiple columns with multiple "do the cells match" scenarios and I'm wanting to get a summary in % and total count for each of the rows.
My logic was to write a bunch of true/false formulas and then another formula to count up the "true" and "false" to get a percentage. I also built in some exclusion criteria where the true/false formula will return a "" when the criteria is not met. The problem I'm having is that I'm not sure how to exclude the blanks from the total count to get a %
Bookmarks