itsjamaalCopper ContributorMay 28, 2024Find qty of products based on total value a = 72,000 b = 68,500 c = 83,000 d = 99,900 x = Qty of a + Qty of b + Qty of c + Qty of d a, b, c & d are constant, only 'x' value changes, I need to find the qty of a,b,c,d Show More
dscheikeyBronze ContributorMay 31, 2024itsjamaal Do you mean a simple sum?=SUM(72000,68500,83000,99900) =SUM(A1,B1,C1,D1) =SUM(A1:D1)
