+ Reply to Thread
Results 1 to 3 of 3

VBA Summing across rows and columns

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    2

    VBA Summing across rows and columns

    I'm hoping to come up with a formula/program to handle the following data:

    Using column A, I want to sum the associated values found in columns B and C for BS rows and subsequent US rows until the next BS row comes up. There is always one BS value, but anywhere from 0-4 US values. If the SUMed values could be placed in column D that would be great!

    Here is a simplified example of what my sheet looks like, I have added the 4th Total Egg Sum column - these are the numbers I'm trying to get without having to individually calculate each sum.

    Excel Forum Help.xlsx

    Any help is much appreciated! Thanks!

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: VBA Summing across rows and columns

    An easy way to do this with formula is to use a helper column
    Insert a Column at the beginning of your data table (this can be hidden), then ...
    In A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag/Fill Down as required.

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

    Drag/Fill Down as required.

    See the attached
    Attached Files Attached Files
    Last edited by Marcol; 07-09-2012 at 12:48 PM.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    07-09-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    2

    Re: VBA Summing across rows and columns

    Thank you so much!! That worked great!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1