Microsoft Office Tutorials and References
In Depth Information
Adding Statistics to the Bottom or Right Edge of Your Data
Figure 2.31. Add an average of the four quarters.
Add an average of the four quarters.
Figure 2.32 shows % Total. This one is very useful and generally hard
to do. The result from this command is the moderately advanced formula
=SUM(B2:F2)/SUM($B$2:$F$19). Figure 2.32 shows that Walmart is 13.90% of
the total revenue. Note that the formula is ignoring column A in the totals
but includes B in the totals, even though B is all text. If you ever had a sec-
tor called “ 7 ” and you stored the name as numeric, it would get added into