a = 72,000b = 68,500c = 83,000d = 99,900 x = Qty of a + Qty of b + Qty of c + Qty of da, b, c & d are constant, only 'x' value changes, I need to find the qty of a,b,c,d

itsjamaal Do you mean a simple sum?=SUM(72000,68500,83000,99900) =SUM(A1,B1,C1,D1) =SUM(A1:D1)

Forum Discussion

Copper Contributor

May 28, 2024

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