+ Reply to Thread
Results 1 to 11 of 11

Counting Up

  1. #1
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    344

    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. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    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
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    344

    Re: Counting Up

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

    Thanks

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    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..
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Counting Up

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

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Counting Up

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

    Merry Christmas

  7. #7
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Counting Up

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

  8. #8
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: Counting Up

    Quote Originally Posted by Fotis1991 View Post
    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. #9
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,199

    Re: Counting Up

    Or use FREQUENCY like,

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

    __________________________________
    "Feedback is the breakfast of champions"

  10. #10
    Registered User
    Join Date
    07-15-2015
    Location
    philippines
    MS-Off Ver
    google sheets
    Posts
    3

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

    Please help. Thanks.

  11. #11
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,505

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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