Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

COUNT with Text and multiple OR statements

Hi All! I am struggling a little with an equation. Overall I am trying to divide count(column1)/count(respondents) in simple terms but it is turning out to be a little harder than that which is where...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

The syntax is a little off.

 

 

DIVIDE(COUNTA(Column1) , IF ( [column1]="1"  || [column2] ="1"  || [column3] ="1"  || [column4] ="1"  || [column5] ="1",count(respondents)),0)