You don't need the parens around the ranges:

=COUNTIF($A:$A, Q1) + COUNTIF($C:$C, Q1) + COUNTIF($E:$E, Q1)