| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
Threaded Mode
