Find qty of products based on total value

Copper Contributor

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

1 Reply

@itsjamaal 

Do you mean a simple sum?

=SUM(72000,68500,83000,99900)
=SUM(A1,B1,C1,D1)
=SUM(A1:D1)