Year on Year - YTD Values....

Options

I have a sheet that includes sales data for the last five years. What I want to achieve is to have a formula that calculates a separate YTD Sales figure for Last Year (YTD) and This Year (YTD) based on a specific date i.e. today's date for This Year(YTD) and a comparable (calculated date) for Last Year (YTD).

Is this even possible?

Thanks in advance for all help.

Answers

  • Ashley Ryder
    Options

    Hi Gary try adapting this one below that i use -

    =COUNTIFS(Date:Date, >DATE(2015, 12, 31), Status:Status, CONTAINS("enquiry", @cell))

    in my sheet this returns or counts the number of Enquiries we have had from 01/01/16 and then i then use another one to calculate the number for the current year by changing the date to 2020,12/31 to give me this years enquiry total - you might be able to adapt somehow to get what you want to do you may need to change count to sumif i think if counting values

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!