View Single Post
  #1   Report Post  
Robin C
 
Posts: n/a
Default How to you count cells that contain any entry?

=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x",2 .5,IF(N9="x",3,IF(O9="x",3.5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what the entry in the cell
is?