• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

YTD sum

V

Veeru106

Member
Hi,
I am looking for a formula which can give me YTD numbers of given scenarios.

Sample file attached where in case 1 we need some of ABC till April and in 2nd scenario we need some of ABC only those in Ind location until Apr’18.

Quick help will be appreciated….thank you
 

Attachments

  • Veeru.xlsx
    11.1 KB · Views: 6
Last edited by a moderator:
Hi Veeru106,
Would it be possible/allowed to change the value in month and have proper dates like 01/01/2018 (formatted as Jan'18)?
Is so, both calculations can be easily achieved with SUMIFS function and a helper column to have the total per row.
Or with SUMPRODUCT without helper column.
See attached if that would be ok to use?
 

Attachments

  • Copy of Veeru.xlsx
    12.4 KB · Views: 5
You must log in or register to reply here.
Back
Top