Countif function in the same row but in alter...

[Guest]

I am trying to carry out a countif function in alternate cells. For example
count the number of cells contaning only the letter A in cells A1, A3, A5, A7
etc..Similarly for the letters B, C and D.

 

[Bob Phillips]

John,

Try this SUMPRODUCT formula

=SUMPRODUCT(--(A1:A10="A"),--(MOD(ROW($A$1:$A$10)-CELL("row",$A$1:$A$10),2)=
0))