Results 1 to 6 of 6

auto sum a different column and end at the first blank cell

Threaded View

dawondr auto sum a different column... 06-30-2013, 02:34 PM
dilipandey Re: auto sum a different... 06-30-2013, 02:44 PM
dawondr Re: auto sum a different... 06-30-2013, 05:13 PM
dilipandey Re: auto sum a different... 07-02-2013, 09:55 AM
dawondr Re: auto sum a different... 07-06-2013, 12:24 PM
dilipandey Re: auto sum a different... 07-08-2013, 03:16 AM
  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    auto sum a different column and end at the first blank cell

    Hi,
    I have a very basic sheet that I use to track my forecast each month. It is an evolving doc meaning I just add the next month to the sheet so I also have a log of what I had in the past.
    If you can look at the attached example, you will see there is no set number of entries for a given month. I'm wondering if I can automatically have the new month I add also create an autosum for that month. I am very flexible where that information can be shown. Yellow or blue cell would be best but I'd even be happy even if it was in the green cell and summed down instead of up. (this will make sense when u see the sheet).
    If it is more than a couple of keystrokes just tell me that it is more work then the benifit of automating and I'd be fine with that answer too, autosumming is easy enough that I can manually do it each month but I think I'm just missing something here in automating the step.

    Thx in advance for your time,

    Dave
    Attached Files Attached Files

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