Percentage of Total in Excel‼️ #excel #exceltips #exceltutorial

[manthandubey]

I WILL BE GRATEFUL IF YOU COULD HELP ME WITH ONE QUERY ACTUALLY I AM MAKING AN EXCELFILE HAVING MULTIPLE sheets what actually it is suppose sheet 1 contains list of product their different quantities and their units to be sold like in yearly format in sheet 2 and sheet 3 we have to employees we want to make sure that employee 1 in sheet 2 sells 45 percent of the unit of a product like if i have product a of 1 lt quantity and total 7000 units i want that insheet 2 under the same product name with same quantity 45 percent of 7000 is shown [basically the number] and in sheet 3 for employee 2 under the same product with same quantity 55 percent of 7000 is seen can you help me i will be obliged if you could do so.

[samnichols]

Or you just do cell reference divided by sum of all the cells. It ain’t rocket science that formula