akinkaraman
Member
In my sheet 2nd row calculates the total of the weights of Upper Deck's pallets (Blue section) due to their Zones and 3rd row calculates the total of the weights of Lower Deck's pallets (Orange section) due to their Zones.
What I need is a formula which gets the total weigts of the zones. I wrote manually the cells names with Sum formula but all pallet weights have their zone names at 2 line belows of their weights and can any formula calculate it without writing all palets's cell's names?
What I need is a formula which gets the total weigts of the zones. I wrote manually the cells names with Sum formula but all pallet weights have their zone names at 2 line belows of their weights and can any formula calculate it without writing all palets's cell's names?