Function COUNTA for alternate cells in a row

[sinecdoque]

Hello,

Maybe this has been asked before but I have a problem with counting cells containing text in alternate columns.
I tried using COUNTA, but then I cannot choose which cells to count. I also tried COUNTIFS(F7:P7,"xxx",F9:P9,"<>0") "xxx" being the title of the columns which I want to be counted. But this function returns the number of times the cells under the title "xxx" are repeated even if they are blank.

Thanks in advance for your help

 

[anandvarma]

try this

Excel Workbook
	A	B	C
1	a	1	3
2	b	0
3	c	1
4	d	0
5	f	1
Sheet4

 

[MikeWx]

If you are counting cells with text only in columns G, I, K, M, and O, the following will work:

=SUMPRODUCT(--(MOD(COLUMN(F9:P9),2)=1),--(ISTEXT(F9:P9)))

 

[sinecdoque]

Thanks both of you for your quick answers.

In the end, I'll go with MikeWx proposal which is precisely what I was looking for.

Cheers!

 

[sinecdoque]

I know I said the solution you gave me worked perfectly, and it does. The only problem is I have three columns to analyse instead of two, so I changed 2 to 3:

=SUMPRODUCT(--(MOD(COLUMN(F9:P9),3)=1),--(ISTEXT(F9:P9)))

And it works for the first two columns but not for the third

=SUMPRODUCT(--(MOD(COLUMN(F9:P9),3)=3),--(ISTEXT(F9:P9)))

Could you tell me what I am doing wrong? Thank you