Hi,
Some cells in column A are copied from a cell in another column (like =C1). C1 has text.
That text is displayed in the A cells, but are not counted in a COUNTIF formula searching for the C1 text in column A.
I imagine the COUNTIF looking on those cells and only finding "=C1", maybe?
Is there a way to fix this?
Thanks
Ed
Some cells in column A are copied from a cell in another column (like =C1). C1 has text.
That text is displayed in the A cells, but are not counted in a COUNTIF formula searching for the C1 text in column A.
I imagine the COUNTIF looking on those cells and only finding "=C1", maybe?
Is there a way to fix this?
Thanks
Ed