Forum Discussion
Help with #REF! Error
Hi! I have a spreadsheet set up which talleys sales for each type of service sold each month (each month is an individual sheet) and then it has a summary sheet which talleys the amount ...
without the sheet it is hard but assuming it is all consistent, you should be able to Copy the formula in another month's column and then replace the sheet name in the formula with 'Mar'. Note that when you copy the formula, if it wasn't done with absolute references ($) then the columns may shift, but hopefully not. Otherwise please provide the sheet or at least a sample of the formula that goes there.
I tried that and it will not reference march. I cant seem to figure out why.