I currently have this formula and it is not working.
=COUNT(I24:U24, I24=0.143,K24=0.285,M24=0.429,O24=0.571,Q24=0.714,S24=0.857,U24=1)
In columns I24:U24 an "x" or "1" can be entered. I am trying to produce a formula that would result in the desired integer noted above. Thus if you place an "x" or "1" in one of the cells I24:U:24 cell X24 would return the corresponding integer. Example: An "X" or "1" in cell M24; would yield in cell X24 0.429. Please help.
Bookmarks