+ Reply to Thread
Results 1 to 6 of 6

SUBTOTAL and COUNTA

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    24

    SUBTOTAL and COUNTA

    Hi all,

    I have a problem.

    Sorry, this is too hard
    Last edited by hungt; 05-03-2013 at 05:28 PM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: SUBTOTAL and COUNTA

    at a first glance the answer is that counta() does not treat text entries the same way as subtotal. subtotal assumes that all the cells are numbers..

  3. #3
    Registered User
    Join Date
    05-02-2013
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: SUBTOTAL and COUNTA

    duplicate of post #1 - deleted
    Last edited by FDibbins; 05-02-2013 at 08:21 PM.

  4. #4
    Registered User
    Join Date
    05-02-2013
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: SUBTOTAL and COUNTA

    Why does my post was cut out?

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: SUBTOTAL and COUNTA

    It would be easier to help/see what you mean, if you upload a sample workbook
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    05-02-2013
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: SUBTOTAL and COUNTA

    Hi all,

    I have a problem
    Last edited by hungt; 05-03-2013 at 05:18 PM.

+ 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