+ Reply to Thread
Results 1 to 7 of 7

cell to equal a count of a row and colum

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    rochester,ny
    MS-Off Ver
    Excel 2003
    Posts
    4

    cell to equal a count of a row and colum

    I am trying to make a cell count only if "c" has a name and "g" has an X in the row that lines up with "C" colum. =COUNTIF(C:C,"James A")*IF(G:G,"X") this is what I am trying but it is not working. Thanks for the help

  2. #2
    Registered User
    Join Date
    12-24-2009
    Location
    Istanbul
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: cell to equal a count of a row and colum

    Try below function;

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-13-2011
    Location
    rochester,ny
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: cell to equal a count of a row and colum

    Thank you. I am trying to learn more and am glad I found this site.

  4. #4
    Forum Expert 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: cell to equal a count of a row and colum

    Mustafaine solution is OK, but please notice that:


    1) IS Array Formula(trl+Shieft+Enter)

    2) Not C:C, but C1:C65000(For Example)

    3) One more ( )

    Then works nice.
    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.

  5. #5
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: cell to equal a count of a row and colum

    1. It's not an array formula and doesn't need to be entered with CSE

    2. C:C will be slower than C1:C65000, but will still work

    3. It has the right number of brackets.

    Other than that you're spot on

  6. #6
    Forum Expert 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: cell to equal a count of a row and colum

    Quote Originally Posted by Andrew-R View Post
    1. It's not an array formula and doesn't need to be entered with CSE

    2. C:C will be slower than C1:C65000, but will still work

    3. It has the right number of brackets.

    O.K I see that both of you are right. Very sorry for this...

    Other than that you're spot on
    Sorry i don't understand what you mean in your last sentence.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: cell to equal a count of a row and colum

    You were asked to edit the previous Thread's title not start a new one. I strongly suggest you read the forum rules before posting again!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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