I'm trying to reduce the size of the number of formulas used in a file.
I have data entry that enters multiple rows of data that make up different product lines and different shifts per day (the DATA tab). The number of formulas used to total each product line to determine the number produced per day is something I'd like to reduce (the TABLE tab). The DATA entered is only for the days worked (between one and four rows of data). The TABLE I created to summarize and calculate the daily data has every day of the year in the first column because production for these lines isn't necessarily done every day the business is open. Is there a way to SUM each days production without having to know the date in advance (I use SUMIFS)? As I mentioned, I have every day of the year listed in COL A. I would like to reduce it to be only the days there are production for the lines I'm tracking so I can remove all of the days of zero production. I'm hoping it helps reduce the file size.
A bit of background: this file is on the company's SharePoint server. I found out (the hard way) that I cannot divide the file into a DATA file and link it to a TABLE/DASHBOARD file to reduce the size of the data entry file. My hope is that reducing the number of lines containing non value calculations I can reduce the file size.
I have data entry that enters multiple rows of data that make up different product lines and different shifts per day (the DATA tab). The number of formulas used to total each product line to determine the number produced per day is something I'd like to reduce (the TABLE tab). The DATA entered is only for the days worked (between one and four rows of data). The TABLE I created to summarize and calculate the daily data has every day of the year in the first column because production for these lines isn't necessarily done every day the business is open. Is there a way to SUM each days production without having to know the date in advance (I use SUMIFS)? As I mentioned, I have every day of the year listed in COL A. I would like to reduce it to be only the days there are production for the lines I'm tracking so I can remove all of the days of zero production. I'm hoping it helps reduce the file size.
A bit of background: this file is on the company's SharePoint server. I found out (the hard way) that I cannot divide the file into a DATA file and link it to a TABLE/DASHBOARD file to reduce the size of the data entry file. My hope is that reducing the number of lines containing non value calculations I can reduce the file size.