+ Reply to Thread
Results 1 to 8 of 8

Sumproduct for visible rows only

  1. 02-17-2014, 02:41 AM #1
    torppo
    torppo is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Sumproduct for visible rows only

    Hi guys,

    I noticed that this issue has been discussed earlier but I just don't know how to apply this subtotal etc. part to my formula. Little bit too tricky for me. So, I need to do Sumproduct for visible rows only and code below needs some changes.

    Please Login or Register  to view this content.
    Cheers,

    Ville
    Reply With QuoteRegister To Reply
  2. 02-17-2014, 04:36 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Sumproduct for visible rows only

    I suggest you post a sample workbook.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-17-2014, 04:42 AM #3
    torppo
    torppo is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Sumproduct for visible rows only

    Dear TMS,

    I don't see any point of posting a sample workbook because it's only because of this one formula. Is there something in that code you don't understand?

    Ville
    Reply With QuoteRegister To Reply
  4. 02-17-2014, 05:11 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Sumproduct for visible rows only

    That's VBA to generate a formula. I don't know what that formula will look like or what cell(s) it goes in ... and then you want to add a SUBTOTAL function to it.

    So, yes, there's a lot about that formula that I don't understand. And I have no plans to create a workbook, populate it in cells unknown with a formula that I don't understand so that I can then try to develop a solution for you.

    Does that answer that question?

    If you don't want to provide enough information to help people help you, you're on your own.

    Note that you have had 40+ views of this thread and only one response; mine. And I'm out.
    Reply With QuoteRegister To Reply
  5. 02-17-2014, 05:50 AM #5
    torppo
    torppo is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Sumproduct for visible rows only

    Dear TMS,

    Attached is a sample spreadsheet...if you're still listening...

    As you can see, at the moment vba writes formulas to cells aa1-ad1 and those formulas works perfectly fine for all data in range a1:w14 but only when unfiltered. Now I want to create formula(s) which will only do the same trick for filtered rows. Hopefully this is much more easy to get the point now. Initially I thought that writing such formula would be much easier, like it was done earlier here.

    Cheers,

    Ville
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-17-2014, 07:03 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Sumproduct for visible rows only

    ...if you're still listening...
    Only because I was interested in how the formula worked and how to apply it here. 


    Please Login or Register  to view this content.

    See the attached updated sample workbook. You can't do this stuff if you don't have the data to work on ...

    Regards, TMS
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-17-2014, 08:44 AM #7
    torppo
    torppo is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Sumproduct for visible rows only

    Hi TMS,

    Works perfectly!! Thank you very much!

    Cheers,

    Ville
    Reply With QuoteRegister To Reply
  8. 02-17-2014, 08:56 AM #8
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Sumproduct for visible rows only

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Table Object after filtering - Count visible rows & First visible row
    By limalf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-13-2013, 07:29 PM
  2. [SOLVED] Sumproduct visible cells
    By Even in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 04:13 PM
  3. Use visible rows from autofilter to build Pivot table. Or use visible rows to Copy/Paste
    By mwhitedesigns in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 10:34 AM
  4. Resize Visible Rows based only on Visible Columns text
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2009, 10:55 AM
  5. [SOLVED] SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY
    By Lisa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-11-2005, 09:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1