Results 1 to 15 of 15

SUMPRODUCT formula working on all but one worksheet

Threaded View

  1. 10-03-2013, 06:38 PM #11
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: SUMPRODUCT formula working on all but one worksheet

    I found the workbook dreadfully slow so re-did the formulae to use SUMIFS instead of SUMPRODUCT. The speed increase on my computer is dramatic. See if it works for you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Sumproduct formula not working
    By cartica in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-20-2013, 11:19 AM
  2. SUMPRODUCT formula not working
    By KINNEY0201 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-28-2010, 12:26 PM
  3. SUMPRODUCT formula with COUNTIF not working
    By Trueman_86 in forum Excel General
    Replies: 2
    Last Post: 07-15-2010, 06:58 AM
  4. SUMPRODUCT across worksheet not working
    By bkatzman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2010, 02:31 PM
  5. SumProduct Formula not working
    By jfwidt in forum Excel General
    Replies: 6
    Last Post: 02-03-2010, 05:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1