One way

=SUMPRODUCT((MOD(COLUMN(A2:O2),2)=1)*(A2:O2="A"))

will count A in A2:O2 in A, C, E etc

--
Regards,

Peo Sjoblom

(No private emails please)


"rutledbr" wrote in message
...
I am trying to use the countif function to add the appearance of value in
cells that are not adjacent to each other. Specifically I have two cells
that
pertain to the same question. For each question I want to compile the
occurence of certain value therefore I want to use the countif function on
every second column.