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
Add expected results as I am not sure what "till Q2" means and "between March till April" mean sum March/April?
For Q1
SUM(D2:F2) ???
so similar for others if you want to sum individual rows
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Yes for Q1 (D2:F2).
For till Q2, it means Jan till June.
Sum data from March till April
Sorry I missing it, 1 question again
Sum data from 1 July till 25 August?
Please add some expected results. Your explanation is not clear.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
See attached with simple SUM as per earliest: till Q4 = 1 year???
If this incorrect, then please post a file with sample of expected results
hi guys...i think i missing it for this case...
for now, this case close
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks