Formula for Calculating percentage in rows
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 autofill.
Countries Total #of Men Total # of Women Total # of Children Total Population Population in %
Canada 345000 456000 567000 1368000 what is the %?
Best Answer

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 Co.  Smartsheet Solution Partner.
Answers

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 Co.  Smartsheet Solution Partner.

Thank you , Gia. Very hepful. Issue resolved.
Help Article Resources
Categories
Check out the Formula Handbook template!