I'm trying to take cells with text, convert that to a number and then summing that column or row. In the example I have the first row's cells (a1:e1) populated with either a "y" or "n". What I want to do is if the cell equals "y" then y=1 and then to sum the row (under the assumption that "n" is blank and therefore equals zero). In my example the sum should be 3 and I keep getting 1. Then to take it a step further I'd like the next formula to count a total sum of "y" + "n" and have it give me a percentage. So the example would be 3y's + 2n's = 5 and y=60%. I've done this so many times before, but it's been awhile and I can't waste anymore time trying to remember.
Thanks in advance!
Bookmarks