+ Reply to Thread
Results 1 to 8 of 8

SUMPRODUCT Numbers only in a filtered range

Hybrid View

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: SUMPRODUCT Numbers only in a filtered range

    1. Unless you have 1,000,000+ rows, do not use SUMPRODUCT with whole column references. It will be slow.

    A sample sheet showing the problem would help hugely (see yellow banner - top of page) because I can not reproduce your problem.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Replies: 3
    Last Post: 05-07-2017, 02:53 PM
  2. [SOLVED] Extracting numbers from text in cell range and summing them up using SUMPRODUCT
    By Jakub2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2017, 07:41 AM
  3. Compare for consecutive row numbers in a filtered range
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2016, 11:23 AM
  4. [SOLVED] Calculate SUBTOTAL of a SUMPRODUCT within a filtered range
    By Lucille Boshoff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2016, 08:45 AM
  5. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  6. Random Selection of Row Numbers from a Filtered Range
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-14-2010, 09:07 AM
  7. Replies: 5
    Last Post: 02-28-2005, 01:51 PM

Tags for this Thread

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