in my worksheet there are 3 columns first - qrt - 2- pint and 3 nip
qrt = 12 , pint = 24 , and nip = 48 no. of bottles per case
when i have fill no. of bottle in these column the sum of bottles were convereted in per case
e.g.
in qrt column
0.1 , 0.2 , 0.5 , 0.2 , 0.2 , 0.3 , 0.6 = 0.21 (sum) bottles
but i want result in per case i.e. = 1.9
In my worksheet there are 3 columns first - qrt - 2- pint and 3 nip
qrt = 12 , pint = 24 , and nip = 48 no. of bottles per case
when i have fill no. of bottle in these column the sum of bottles were convereted in per case
e.g.
in qrt column
0.1 , 0.2 , 0.5 , 0.2 , 0.2 , 0.3 , 0.6 = 0.21 (sum) bottles
but i want result in per case i.e. = 1.9 because
i put the formula of =sum(a2:a20)/12*100
but the result is =17.5
i want result is = 1.9
If you have 1 bottle in a case of 12 bottles then the case is filled with 1/12 bottles.
If you have 0.21 of a bottle in a case of 12 bottles then the case is filled with 0.21/12 bottles.