I don't understand why I keep getting #REF error in a column of sumifs.
I consolidate several spreadsheets into one. I delete the unneeded information. I save the spreadsheet. I always save to the same location with the same name so it over writes the existing sheet.
On another spreadsheet I have a column that sumifs from that first cleaned up data workbook. But, I have to redo it every time. It opens with a #Ref error and I get to redo the sumifs. I know I could save a snip of the formula and just copy it down the column again. I don't like that because other people might find the method useful and as it is it is clunky.
Any ideas?
Bookmarks