+ Reply to Thread
Results 1 to 3 of 3

Faster alternative to sumifs and averageifs needed

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    Birmingham
    MS-Off Ver
    2010
    Posts
    4

    Faster alternative to sumifs and averageifs needed

    Morning all,

    Hopefully somebody will be able to help me with this.

    I am currently building a call centre dashboard to track call handler stats.

    I have used sumifs and averagesifs to calculate data between 2 dates for a selected handler, but its already quite slow with roughly 20000 rows of data, it will expand up to about 1000000 rows.

    I am unable to attach the live dashboard, but I have attached a basic sheet to show where the data comes from and how the averageifs/sumifs work.
    Sheet1 is where the raw data extract is, and sheet 2 holds my formula's

    Any help will be appreciated and i'll answer any questions ASAP.

    Thanks
    Dan
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Faster alternative to sumifs and averageifs needed

    SUMIFS would be fastest.
    However, you can try with Pivot Table if you like.

    I've inserted aditional column in the Table and then use filter by this table.

    Each time you change dates in Sheet3 you need to right click on the Pivot Table and click "Refresh".
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-29-2015
    Location
    Birmingham
    MS-Off Ver
    2010
    Posts
    4

    Re: Faster alternative to sumifs and averageifs needed

    Thanks for the quick reply Zbor,

    Looks like this is exactly what I need.

+ 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] Alternative and faster code
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2013, 09:31 AM
  2. Replies: 9
    Last Post: 12-18-2012, 04:33 PM
  3. Alternative faster way to do the same thing
    By mrall in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2011, 03:33 AM
  4. Excel 2007 : AVERAGEIFS alternative
    By shaunk in forum Excel General
    Replies: 5
    Last Post: 04-09-2009, 09:20 AM
  5. Faster alternative to SUMPRODUCT?
    By speakers_86 in forum Excel General
    Replies: 4
    Last Post: 10-03-2006, 10:07 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