# Formula for Calculating percentage in rows

Options
✭✭

Please below is a dummy example and I need the formula for finding the population percentage so that I can apply the same formula to other rows by clicking and dragging to auto-fill.

Countries Total #of Men Total # of Women Total # of Children Total Population Population in %

Canada 345000 456000 567000 1368000 what is the %?

• ✭✭✭✭✭✭
Options

Hi @daoppong,

Just create columns of % with formulas in each column as below screenshot:

% Men : `=[Total #of Men]@row / [Total Population]@row`

% Women :` =[Total # of Women]@row / [Total Population]@row`

% Children: `=[Total # of Children]@row / [Total Population]@row`

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

• ✭✭✭✭✭✭
Options

Hi @daoppong,

Just create columns of % with formulas in each column as below screenshot:

% Men : `=[Total #of Men]@row / [Total Population]@row`

% Women :` =[Total # of Women]@row / [Total Population]@row`

% Children: `=[Total # of Children]@row / [Total Population]@row`

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

• ✭✭
Options

Thank you , Gia. Very hepful. Issue resolved.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!