DashboardNovice
Member
My COUNTIF formula is not picking up a colon in cell A3:
There is text on both sides of the colon. The data was downloaded from QuickBooks and the cell is text format. It returns a 0.
What is wrong with my formula?
Code:
=COUNTIF(A3,":")
There is text on both sides of the colon. The data was downloaded from QuickBooks and the cell is text format. It returns a 0.
What is wrong with my formula?