=B1/$B$11

regards,

Peo Sjoblom

"bvi" wrote:

if cells b1-b10 have random #'s & are totaled in b11 & i put in the formula
in cell c1 of +b1/b11 to get the % of b1 of the total // how can i copy this
formula to c2-10 & make the 2nd half of the formula reference b11 only?