Hopefully this explanation is clear.
In column A, we have apples, and oranges. An actual application of this would have hundreds of types of fruit. Column B has differing amounts of each fruit for each day. Column C has a a number which will be the divisor of the sum of apple values in column b, orange values in column b, etc. See attached example. Thanks!
Bookmarks