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 auto-fill.
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!