+ Reply to Thread
Results 1 to 3 of 3

Sum If Only Visible Cells

  1. #1
    Registered User
    Join Date
    07-21-2012
    Location
    Cannock, England
    MS-Off Ver
    2007
    Posts
    11

    Sum If Only Visible Cells

    Hi,

    I am currently stuck with a formula to only do a SUMIF on only visible cells,

    Is there another way to do it, I have tried to do a subtotal,109 but that will not work.

    Any help would be appreciated




    Please Login or Register  to view this content.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,261

    Re: Sum If Only Visible Cells

    not sure what you are trying to do, but have you tried using sumifS()?

    if that is not what you need, then perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
    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

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Sum If Only Visible Cells

    If you are having trouble with subtotal() and it is because of syntax...this will help:

    http://www.ozgrid.com/Excel/excel-subtotal-function.htm

    Of course, if your situation does not allow for subtotal, then that will likely not help too much, and posting an example of your issue would help us figure out what to do next.

+ 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