Results 1 to 8 of 8

SUM using string tag as start point

Threaded View

chaz SUM using string tag as start... 10-18-2006, 06:35 PM
Bryan Hessey =SUM(INDIRECT("B"&MATCH("base"... 10-18-2006, 08:39 PM
chaz Bryan, Wouldn't using... 10-18-2006, 09:06 PM
Bryan Hessey Of course, but the response... 10-18-2006, 09:40 PM
chaz Bryan, I appologize for not... 10-18-2006, 09:47 PM
  1. #1
    Registered User
    Join Date
    05-19-2006
    Posts
    7

    SUM using string tag as start point

    Data looks like this:

    DATE AMOUNT
    23-Sep-06 $1000.00
    29-sep-06 $1500.00
    06-Oct-06 BASE
    12-Oct-06 $1200.00
    16-Oct-06 $1425.00
    . . .

    I want to sum all the values in the AMOUNT column from the cell following the "BASE" entry to the end of the column.

    My initial attempt: SUM(IF($A:$A > LOOKUP("BASE",$B:$B,$A:$A),$B:$B ))
    The thought being to find the date of the "BASE" entry and sum all of the values with a date greater than that.

    I need to be able to move the "BASE" entry around and have the sum automatically work.
    Also I need to be able to add rows of data and have the formula automatically work.

    Any ideas greatly appreciated.
    -chaz
    Last edited by chaz; 10-18-2006 at 09:12 PM.

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