Hi, this is my sample sheet, I need YTD total in each column by product once the month name changes. below is my data set, please can you advise which formula will work for YTD Net sales calculation and also for Quarter to date Net Sales figures.
should work , although if you change the title ACT-2020 so it matches the data ACT 2020
Not sure of columns or rows in your picture
If you use 2XLBB - see add-in in menu or my signature
OR use something like onedrive / dropbox and link to a sample spreadsheet
Not sure what you mean by
I need YTD total in each column by product once the month name changes.