I have a formula which I want to alter to include three more cells in a column, but when I change the formula, I get a division error:
This is the formula: =SUM(1/COUNTIF(C4:C26,C4:C26))
...I want to add 3 more cells, so I modify to this:
The modified formula gives me a division error: #DIV/0!
The odd thing is there are values in all the cells.