Results 1 to 4 of 4

Sum based on next column

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    Hyderabad
    MS-Off Ver
    2013
    Posts
    4

    Sum based on next column

    HI All,

    Wondering if some could help me to solve this. Attached the sheet.

    Col A: Date
    Col B: Target
    Col C: Achieved

    As soon i enter the achieved number on the particular date the target should calculate automatically till that date.

    Example: Attached sheet achieved has till 14th August and target total should sum up till 14th August.

    Thanks 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. [SOLVED] Sum values in Column A, based on dates in Column B & if value in Column C = True
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-25-2016, 12:03 PM
  2. Replies: 3
    Last Post: 03-22-2014, 08:35 AM
  3. [SOLVED] Match existing column name, copy based based on matching name, drag till end
    By Amolvijay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 04:20 PM
  4. Replies: 2
    Last Post: 06-06-2013, 08:29 AM
  5. [SOLVED] Filtering and generating new tabs based on Unique values based in column
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2012, 09:40 PM
  6. Replies: 2
    Last Post: 08-09-2009, 12:58 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