Could someone help me create a function please?
I would like a cell to give me a count based on the contents of a column.
I have the following column. If the cell contains "N" it should add 1 to the count. If the cell contains a name, it should add 0.5 to the count. If the cell is strikethrough it should be ignored.
Thanks in advance!
I would like a cell to give me a count based on the contents of a column.
I have the following column. If the cell contains "N" it should add 1 to the count. If the cell contains a name, it should add 0.5 to the count. If the cell is strikethrough it should be ignored.
Thanks in advance!