+ Reply to Thread
Results 1 to 5 of 5

SUMPRODUCT/SUMIF Issues

Hybrid View

  1. 05-29-2014, 10:08 PM #1
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: SUMPRODUCT/SUMIF Issues

    Hi Justin,
    Welcome to this forum.
    May I ask you some questions?
    Would it be possible for you to have only one sheet to track production time? You would need more columns to detail every entry but then you'll be able to use pivot table to work out your summary sheet for you.

    If you stick with your actual plan, one thing you could do is to make your INDEX named range a dynamic one and to add new sheet's name at the end of Index when someone hit the generate new sheet button. This will keep your old formula working forever.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.
    Reply With QuoteRegister To Reply
  2. 05-30-2014, 03:48 AM #2
    Jskrilla
    Jskrilla is offline
    Registered User
    Join Date
    04-25-2014
    Location
    Alaska
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: SUMPRODUCT/SUMIF Issues

    Thanks for the reply Pierre!

    I can't have a single sheet, as each sheet will be used as a timesheet for each employee and sent to our accounting department. I like your idea for the dynamic range, I forgot that Excel had that feature; the next question is what would be the correct macro or VBA coding to apply the additional sheets to the dynamic range? I also see the need to have the worksheet names (on the tab) auto-populate to the dynamic range, so that if a user changes the text on the tab, the dynamic range stays intact.

    Making progress, progress is good! Thanks for everyone that has looked, and thank you Pierre!
    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. SUMIF and SUMPRODUCT issues
    By djbcktt in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-19-2013, 05:38 PM
  2. sumproduct issues
    By Dyakin in forum Excel General
    Replies: 6
    Last Post: 03-29-2012, 10:03 AM
  3. Issues with Sumproduct
    By Chareth Cutestory in forum Excel General
    Replies: 6
    Last Post: 09-02-2011, 06:08 PM
  4. sumproduct issues
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2008, 11:38 AM
  5. [SOLVED] SUMPRODUCT issues
    By Ashlynn Grace in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-26-2006, 05:00 PM

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