Hi All,
I have been trying to utilise SUMIFS to build a formula based on date range but seem to keep hitting brick walls.
Per the test file attached I have a list of values for each month in the columns and the corresponding categories in the rows. I would like to add a YTD total but based on the a set month only so each month this can be updated therefore the total will only include months past such as Jan, Feb in Mar & Jan, Feb, Mar in Apr etc. I don't want to fix this value so would simply just prefer an option to enter it manually as the period to calculate to.
Many thanks,
Bookmarks