Formula for Calculating percentage in rows

daoppong

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 %?

Gia Thinh

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

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

daoppong

Thank you , Gia. Very hepful. Issue resolved.