Why isn't this working: =COUNTIF(Column Name: Column Name)
you need brackets around your column names, and a criteria.
Try this:
=COUNTIF([Column Name]:[Column Name], "Test")