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

J

John@finland

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.
 
B

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))
 
Top