Lets say the first number (100) is in cell A1, the other two below that.
2nd set of numbers at B1, the other two below that.
The Calculations in Column C are (top cell to bottom cell)
=SUM(B1/A1)
=SUM(B2/A2)
=SUM(B3/A3)
AND the cells are Formatted in the Numbers, Percentages, 2 Decimal places.
I hope that is clear as Mud 
I think its =SUM(C4*100%). ie if your total is in C4 then use that. If it's in cell d4, use that. See if that works.
@happyroo_bunji wrote:ok I see what you mean, I'll see if I can come up with anything.
Another dumb question, why do you want to know this, I mean its easy enough to see, you have 100 stock on hand thats 100%
cause sometimes you just got to do what you are told
thanks everyone will give it a whirl when back on my desktop
@*mrgrizz* wrote:cause sometimes you just got to do what you are told
thanks everyone will give it a whirl when back on my desktop
lol I understand
The formulas others posted should work
