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 "...
Hi Jeff,
COUNTIFS() takes criteria with AND condition. Other words you try to calculate number of cells which simultaneously are "One" and "Three". No such.
Try this
=(COUNTIF(H2:H100,"ONE")+COUNTIF(H2:H100,"TWO"))/((COUNTIF(H2:H100,"Three")+COUNTIF(H2:H100,"One")))
It worked! Thanks! :)