+ Reply to Thread
Results 1 to 7 of 7

Loop function SUMIFS

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Loop function SUMIFS

    Hello everyone,

    Can you help me build this loop for the next function? Thanks!!

    Please Login or Register  to view this content.
    It goes the same until:
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Loop function SUMIFS

    Use something like this
    Please Login or Register  to view this content.
    Regards,
    amotto

    If I helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Re: Loop function SUMIFS

    Thank you very much!! It works.

    And when it change rows and columns? how do you do it? lets say in here:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Loop function SUMIFS

    try this:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Loop function SUMIFS

    try this:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Re: Loop function SUMIFS

    Thank you, I really appreciate it!!, I had to change some parts cuz it wasnt working that way but you gave me the idea!! thanks a lot.

    at the end was like this:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Loop function SUMIFS

    oh yes, hah. mine probably never moved cells, so you do need that select line in the for loop. I am glad you got it fixed. Unlike in your case, most of the time you do not need to use select lines. Your other code was pretty messy, it looked like excel created it from a macro builder, which is fine, but will run slower in the long run.

+ 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] NEED HELP! SUMIFS function
    By thedefense in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2012, 08:47 PM
  2. [SOLVED] SUMIFS function?
    By jed38 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2012, 04:33 PM
  3. OR function in SUMIFS
    By skysurfer in forum Excel General
    Replies: 6
    Last Post: 05-09-2012, 02:41 AM
  4. Excel 2007 : SUMIFS function & #VALUE error
    By arangoa79 in forum Excel General
    Replies: 7
    Last Post: 11-19-2009, 06:00 PM
  5. Need help with SUMIFS function please
    By mTriniDee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2008, 11:50 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