I want to include a new condition (within a date range and calculate) in the existing formula, but couldn't figure out how. Can you please help me add that condition?
I have formula in F2:F8 and this is the formula in F2
I want to add a condition, calculate if it's within the date range specified in E1 and F1 which is last one year.
Please Login or Register to view this content.
I have enclosed a sample file, please find the attachment.
SAMPLE.xlsx
Last edited by TK2013; 07-04-2023 at 12:24 PM.
Please tell us what are your expected results and why (and add the expected results to your sheet)?
Please talk about your business and not about formulas.
try
Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
The expected result is for the last one year, and don't want or remove the previous year datas in the calculation.Originally Posted by HansDouwe
Perfect, it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks