+ Reply to Thread
Results 1 to 6 of 6

Using sumif or sumproduct with visible rows only in filter mode

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Using sumif or sumproduct with visible rows only in filter mode

    Hello everyone
    I have data in columns .. I need to use sumproduct function and get the results for visible rows only
    Is that possible by formulas or I have to use vba codes?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Using sumif or sumproduct with visible rows only in filter mode

    You could use SUBTOTAL(109,range here). That only looks at the visible rows.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Using sumif or sumproduct with visible rows only in filter mode

    How can use subtotal with sumproduct ?

  4. #4
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Using sumif or sumproduct with visible rows only in filter mode

    It doesn't work the same, but it could be possible to redesign the formula you are using. Sumproduct doesn't have a way to filter out the cells that aren't visible.

    If you post a sample of your worksheet with your formula and the expected results, it may be possible to figure out a different way of doing what you want without using sumproduct. If VBA is required your sheet could also help someone write that code as well.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Using sumif or sumproduct with visible rows only in filter mode

    Thanks sir for your reply
    I have found solution by using UDF function
    Here's the link
    http://www.excelforum.com/excel-prog...t=#post4123198

  6. #6
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Using sumif or sumproduct with visible rows only in filter mode

    Nice job. Thanks for sharing the link.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct for visible rows only
    By torppo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2014, 08:56 AM
  2. [SOLVED] Sumproduct/Sumif/Subtotal with a Filter
    By wf44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2014, 11:12 AM
  3. Copy visible cells from Row B paste to Row A in filter mode
    By lakshmipathi123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2012, 03:37 PM
  4. delete the rows in the filter mode
    By manieswar in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-16-2010, 05:14 PM
  5. Any way to make SUMIF only compute visible rows?
    By gtzpower in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2007, 11:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1