|Posted: June 2, 2015, 2:48 pm - IP Logged|
I'm trying to create a formula that gives the result of the number of cells in a row that contain text. For example if I have four cells in a row and three contain text the result would be 75%, if I have seven cells in a row and four have text the result would be 57%.
This is what I have so far... =COUNTA(B9:H9)/COUNTA(B9:H9)
Not sure if this is what you need:
I have a list of numbers and letters in cell range A1 through A100
In cell C1 the formula is:
Right click the cell C1, select the Number Tab, Select Percentage, I selected 1 decimal place.