# Counting Up

1. ## 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

2. ## Re: Counting Up

Hi Morgan.
Pls try this
=COUNTIF(Q2,T2,W2,Z2,AC2,AF2,AI2,AL2,AO2,AR2,AU2,AX2,3)

When you use numbers, no need of "".

Hope to helps you

3. ## Re: Counting Up

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

Thanks

4. ## Re: Counting Up

Sorry i did't saw well, your needs..

The classic way for this is this(The range that you use is not continius..):

``Please Login or Register  to view this content.``
I'll search for sorter formula..

5. ## Re: Counting Up

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

6. ## Re: Counting Up

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

Merry Christmas

7. ## Re: Counting Up

With 2007 and above, you could also try
``Please Login or Register  to view this content.``

8. ## Re: Counting Up

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

9. ## Re: Counting Up

Or use FREQUENCY like,

=INDEX(FREQUENCY((Q2,T2,W2,Z2,AC2,AF2,AI2,AL2,AO2,AR2,AU2,AX2),{2,3}),2)

10. ## Re: Counting Up

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*")

11. ## Re: Counting Up

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1