Forum Discussion
Formula Issues
What is the formula to divide words in a column to reach a percentage? For example, if the words are "One""Two""Three" I'm looking to divide the total amount of "One"and"Two" by the total amount of "...
The best I can think of is the following, except I am met with the DIV/0 error.
=COUNTIFS(H2:H100,"ONE",H2:H100,"TWO")/(COUNTIFS(H2:H100,"THREE",H2:H100,"ONE"))