Year on Year - YTD Values....

Gary Thornton

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.

Ashley Ryder

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