Hi guys,
Im not too sure how to explain what I need to formulate, but I have a sheet where I will put availablities of items into cells, then in another cell add the items that are available into a different cell, but the items that are availible in the first place, make up a different item, so the formula will somehow need to be say 1+1+1=1, but then the 1 that it makes up will need to have a higher value if the items that are available to make up have more then 1 stock.
Makes sense? Im scratching my head with a need of answers here.. If someone can help me out that would be awesome.
Im not too sure how to explain what I need to formulate, but I have a sheet where I will put availablities of items into cells, then in another cell add the items that are available into a different cell, but the items that are availible in the first place, make up a different item, so the formula will somehow need to be say 1+1+1=1, but then the 1 that it makes up will need to have a higher value if the items that are available to make up have more then 1 stock.
Makes sense? Im scratching my head with a need of answers here.. If someone can help me out that would be awesome.
