Counting Up

Morning,

I'm trying to count up the number of times the value 3 is in the following columns, I've tried:

=COUNTIF(Q2,T2,W2,Z2,AC2,AF2,AI2,AL2,AO2,AR2,AU2,AX2,"3")

But it doesn't seem to work (error message) and I can't work out what I'm doing wrong, any ideas please?

Many thanks

Thanks, but when I try that it says I have sued 'too few arguments'

Thanks

Perhaps =SUMPRODUCT(--(MOD(COLUMN(Q2:AX2)-COLUMN(Q2),3)=0),--(Q2:AX2=3))

With 2007 and above, you could also try

Please Login or Register  to view this content.

Originally Posted by Fotis1991

o!!! What's a great formula, arthurbr!

Thx Fotis
I just happened to see that there were always two cells between he cells to be counted

Merry Christmas to you too

Hi,

I am not sure if my question is related to this post. But Im gonna try, hoping someone can help me.

I have INFLUENCERS to Categorize and Tag as my File # 1 and TAGGER Team Stats as file # 2. These 2 different files. I would like to use COUNTIF wherein it will count # of certain word in a cell in file # 2, e.g., Patrick then return the numbers in file # 2.

This is my initial formula but I kept on getting an error.

=COUNTIF('[INFLUENCERS to Categorize and Tag]Set 1'!$G:$G,"*a*")

Please help. Thanks.