Results 1 to 7 of 7

Help with sum function on a column

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2015
    Location
    canada
    MS-Off Ver
    2011
    Posts
    4

    Help with sum function on a column

    Hello

    Hope you are all well. Here is the issue and hope someone can give me a hand.

    I attached a file for this question.

    I have a column with numbers on every cell that belong to a range. Each range is separated by a blank cell. I need a formula I can drag all the way down, to sum all cells starting from the first range, sum up all values until right before an empty cell, get the total, then continue down start summing up the next range, and so on... I can do this by selecting the SUM(b4:b28), but each range could have more or less numbers down so I would have to manually select each range and use this function. The only thing that separates each range is an empty cell.

    Hope someone can give me a hand.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-13-2013, 12:27 AM
  2. Replies: 4
    Last Post: 03-04-2013, 01:41 AM
  3. [SOLVED] Expand on Parse Function/ Column to Column - Contiguous Data to include quantities
    By arcamp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2013, 05:18 PM
  4. Worksheet function to Autofill formula in column A when data entered in column B
    By boylers75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 02:27 PM
  5. Replies: 4
    Last Post: 09-01-2010, 10:22 AM

Tags for this Thread

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