Hi,
I have a row of numbers that are number of kg's. However I need to split these numbers based on how many kg's were fed to different pens. For example the 1st row is the total mix size and the rows below will reference this row based on the proportion of feed i.e. total mix size 2,500kgs; 1st pen fed 800kg's so each ingredient that goes into the was fed 32% of this mix to 1st pen.
I am currently entering all this information manually and would like to automate if possible. The obstacle is the 1st row (total mix size) cannot be included in end of month totals. So is it possible to reference a cell then hide it & not have it included when summing totals?
This maybe easier if I forward anyone that would like to help a copy of the file.
Many thanks!
I have a row of numbers that are number of kg's. However I need to split these numbers based on how many kg's were fed to different pens. For example the 1st row is the total mix size and the rows below will reference this row based on the proportion of feed i.e. total mix size 2,500kgs; 1st pen fed 800kg's so each ingredient that goes into the was fed 32% of this mix to 1st pen.
I am currently entering all this information manually and would like to automate if possible. The obstacle is the 1st row (total mix size) cannot be included in end of month totals. So is it possible to reference a cell then hide it & not have it included when summing totals?
This maybe easier if I forward anyone that would like to help a copy of the file.
Many thanks!
