Results 1 to 6 of 6

Summing Data With Criteria Q1, till Q2, till Q3 etc...

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Summing Data With Criteria Q1, till Q2, till Q3 etc...

    hello all..

    i'm looking for formula to summing data with accumulative number based date criteria.
    i want to sum for this:
    1. Q1 (quarter)?
    2. till Q2?
    3. till Q3?
    4. till Q4?
    5. between Marc till April?
    6. 1 full year

    my target in the same line/rows in "yellow area" (start cell Q2 down right)
    please , don't use array function or pivot table if possible.

    this file attachment

    anyone help me, thank you so much

    john m
    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. Max function Based on previous entries criteria pattern till current row
    By dorabajji in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-15-2020, 05:09 AM
  2. Replies: 2
    Last Post: 02-02-2017, 05:18 AM
  3. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  4. [SOLVED] How to loop till last row with data?
    By btmtdk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2012, 10:37 AM
  5. using data till till the current row
    By nilu8603 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2010, 04:30 AM
  6. Excel 2007 : using data till current row
    By nilu8603 in forum Excel General
    Replies: 1
    Last Post: 01-26-2010, 12:48 AM
  7. Finding last row till data is there and calculating
    By rajaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2009, 12:03 PM

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