+ Reply to Thread
Results 1 to 9 of 9

Slow on transposed sumifs formula

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Slow on transposed sumifs formula

    Hi, I need another help with my formula, please..

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    As time goes by, I often copy this formula to some other cell but it is slowing the calculation of my workbook..
    Maybe I could make the calculation to run manually with F9, But it often uncomfortable..
    Could you help to make this formula a bit lighter, please..?
    thank you..
    Last edited by eing; 04-30-2014 at 03:29 AM.

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Heavy Formula

    Can u post a workbook with insensitive data as a sample, along with the sample result that you expect to get?

    Sarang

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Heavy Formula

    At present you are having the right formula with perfect combination and one thing can be done to make it speeder (i.e.) moving the Index function in a separate cell will show little bit of speed in performance


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

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

    Re: Heavy Formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  5. #5
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Re: Slow on transposed sumifs formula

    Here's the sample workbook..
    slow.xlsx

    If I should move the index function, I really have no idea on how to do it..
    Will you help me to do it please..?

  6. #6
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Slow on transposed sumifs formula

    I suspect the OFFSET formula (volatile!) are slowing down things too!

    Try these instead

    In A10
    =INDEX('Sheet 1'!$H$1:$ADB$1,ROW(A1))

    In C10
    =INDEX('Sheet 1'!$H$3:$ADB$3,ROW(A1))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  7. #7
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Re: Slow on transposed sumifs formula

    Hi Ace,
    I'd already try it, but my workbook keep slowing..
    I suspected the sumifs formula because my workbook get lighter when I delete some of the sumifs formula..
    Any idea..?
    Well thanks for the attention..

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Slow on transposed sumifs formula

    Keep the file in binary format and check

  9. #9
    Registered User
    Join Date
    07-15-2013
    Location
    jakarta
    MS-Off Ver
    2007
    Posts
    95

    Re: Slow on transposed sumifs formula

    I save my file in Binary format but it still slow..
    Any more idea..?

+ 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] Too heavy and slow.
    By heuder in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2014, 09:29 AM
  2. An Excel heavy user
    By tchello_66 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-20-2014, 08:07 PM
  3. Macro file has become too heavy
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 03:16 PM
  4. File has become very heavy
    By Suraj3825 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2013, 02:49 PM
  5. Counting heavy atoms in chemical formula
    By Dr Van Nostrand in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2013, 03:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1