Calculating percentages

[Guest]

These are the figures in my table:
Region 1 2305 1483 824
Region 2 1281 1782 1005
Region 3 1885 2285 721
Region 4 2100 2108 1287

Says to enter a formula that uses absolute cell references to calculate the
percentage of units sold per region. My textbook doesn't give an example of
this and I'm sure it's simple, but I can't figure it out. Can someone please
help me ASAP? Thanks

 

[Bernard Liengme]

Not sure what the tree columns are, but assume they are quarterly data.
Suppose the text "Region 1" is in A1
The total for Region1 is =SUM(B11)
The grand total is =SUM(B14)
The fraction of all sales that were in Region 1 is =SUM(B11)/SUM(B14)
If this is put in E1 and formatted as percentage, we get answer for Region 1
But if we copy this down to E2 we get =SUM(B22)/SUM(B25); we wanted the
numerator to change but not the denominator so we use in E1
=SUM(B11)/SUM($B$1:$D$4) which when copied to E2 will become
=SUM(B22)/SUM($B$1:$D$4) giving the correct result for Region2

Look in Help under Relative and Absolute
Learn how to use F4 to add the $ - quicker than typing


best wishes