+ Reply to Thread
Results 1 to 7 of 7

Add number of columns, number depends on different cell

  1. 05-27-2013, 01:11 AM #1
    carrus
    carrus is offline
    Registered User
    Join Date
    05-23-2013
    Location
    Perth, Australia
    MS-Off Ver
    2010
    Posts
    9

    Add number of columns, number depends on different cell

    Hi,

    Im looking to write a macro which will do the following and any help would be very appreciated.
    I want to sum cells N8 - Y8. But, the number of cells that is summed depends on cell A1. For example, is A1 reads 5 I want to sum N8 - R8.
    Thank you in advance!
    Reply With QuoteRegister To Reply
  2. 05-27-2013, 01:25 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Add number of columns, number depends on different cell

    Please explain if A1 is 12 then what needs to be done in that case?


    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
    Reply With QuoteRegister To Reply
  3. 05-27-2013, 01:25 AM #3
    Ed_Collins
    Ed_Collins is offline
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Re: Add number of columns, number depends on different cell 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 05-27-2013, 01:32 AM #4
    carrus
    carrus is offline
    Registered User
    Join Date
    05-23-2013
    Location
    Perth, Australia
    MS-Off Ver
    2010
    Posts
    9

    Re: Add number of columns, number depends on different cell

    then N8 - Y8 needs to be summed
    Reply With QuoteRegister To Reply
  5. 05-27-2013, 01:38 AM #5
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Add number of columns, number depends on different cell

    Quote Originally Posted by carrus View Post
    then N8 - Y8 needs to be summed
    Try this...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-27-2013, 01:40 AM #6
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add number of columns, number depends on different cell

    maybe
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-27-2013, 09:19 PM #7
    carrus
    carrus is offline
    Registered User
    Join Date
    05-23-2013
    Location
    Perth, Australia
    MS-Off Ver
    2010
    Posts
    9

    Re: Add number of columns, number depends on different cell

    thank you nilem your formula worked perfectly
    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)

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