Hi,
Thank you for reading this. I have attached a sample data sheet to this post.
2 formulas needed:
1- I am trying to sum data for a office for the current year. (All 2019)
2-Then I am trying to sum data for the previous year through same time frame. (1/1/2018 - 10/20/2019)
I can use this =SUMIF(A2:A9,"<="&D14,INDEX(B2:D9,,MATCH(D13,B1:D1,0))) to get the total sum for correct column -but I need to get the date range implemented for them.
Thank you for your consideration.
-David
Bookmarks