Hello,
I am hoping that someone can help me with my issue.
I have posted an example of my data below in "FIG 1".
I would like to create formulas in columns C & D that will change when I filter on the "Division". (i.e. FIG 2) It is also possible that I might want to filter on another column such as column E (not shown), so the formula can't be based on column A.
Basically, I want the formula in column C to cume the dollars in column B not matter how I filter the data (same for column D).
Hope this makes sense. Thanks, Zep
FIG 1
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Ckembd25%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 379pt; margin-left: 4.9pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="505"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 73pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="97"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 88pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" id="_x0000_s1026" x:autofilter="all" width="117"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 120pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" id="_x0000_s1027" x:autofilter="all" width="160"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 98pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" id="_x0000_s1028" x:autofilter="all" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="1215346.375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="1215346.375" x:fmla="=B2" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="6.0606615951703535" x:fmla="=(C2/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="1213988.125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="2429334.5" x:fmla="=C2+B3" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="12.114549900206327" x:fmla="=(C3/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="1090495" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="3519829.5" x:fmla="=C3+B4" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="17.552605504910211" x:fmla="=(C4/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="988800.8125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="4508630.3125" x:fmla="=C4+B5" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="22.483534853830999" x:fmla="=(C5/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="983855.6875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="5492486" x:fmla="=C5+B6" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="27.389803966141617" x:fmla="=(C6/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="973895.3125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="6466381.3125" x:fmla="=C6+B7" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="32.246402907480601" x:fmla="=(C7/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="922473.875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="7388855.1875" x:fmla="=C7+B8" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="36.846574596609535" x:fmla="=(C8/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="823414.9375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="8212270.125" x:fmla="=C8+B9" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="40.952761434576487" x:fmla="=(C9/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="737271.6875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="8949541.8125" x:fmla="=C9+B10" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="44.629371077352353" x:fmla="=(C10/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="696152.4375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="9645694.25" x:fmla="=C10+B11" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="48.100928181672082" x:fmla="=(C11/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="695702.875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="10341397.125" x:fmla="=C11+B12" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="51.570243417966019" x:fmla="=(C12/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="694631.875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="11036029" x:fmla="=C12+B13" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="55.034217815876794" x:fmla="=(C13/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="670833" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="11706862" x:fmla="=C13+B14" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="58.379512526508506" x:fmla="=(C14/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="653262.8125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="12360124.8125" x:fmla="=C14+B15" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="61.637188626683411" x:fmla="=(C15/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="649721.3125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="13009846.125" x:fmla="=C15+B16" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="64.877204055398067" x:fmla="=(C16/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="641408.75" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="13651254.875" x:fmla="=C16+B17" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="68.075766586948987" x:fmla="=(C17/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="631476.375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="14282731.25" x:fmla="=C17+B18" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="71.224798577289917" x:fmla="=(C18/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="628807.0625" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="14911538.3125" x:fmla="=C18+B19" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="74.360519300911307" x:fmla="=(C19/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="604335.25" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="15515873.5625" x:fmla="=C19+B20" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="77.374204547870377" x:fmla="=(C20/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="594263.875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="16110137.4375" x:fmla="=C20+B21" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="80.337666091588403" x:fmla="=(C21/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="581241.6875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="16691379.125" x:fmla="=C21+B22" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="83.236188887563543" x:fmla="=(C22/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="570439.125" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="17261818.25" x:fmla="=C22+B23" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="86.080841711142412" x:fmla="=(C23/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="564287" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="17826105.25" x:fmla="=C23+B24" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="88.894815258028487" x:fmla="=(C24/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="560155.875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="18386261.125" x:fmla="=C24+B25" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="91.688187804946679" x:fmla="=(C25/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="559712.5625" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="18945973.6875" x:fmla="=C25+B26" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="94.4793496511966" x:fmla="=(C26/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="555503.5625" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="19501477.25" x:fmla="=C26+B27" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="97.249522152204023" x:fmla="=(C27/$C$28)*100" valign="bottom" width="131"> </td> </tr> <tr style="height: 13.5pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 13.5pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 13.5pt;" x:num="551554.1875" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 13.5pt;" x:num="20053031.4375" x:fmla="=C27+B28" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 13.5pt;" x:num="" x:fmla="=(C28/$C$28)*100" valign="bottom" width="131"> </td> </tr> </tbody></table>
FIG 2
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Ckembd25%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 379pt; margin-left: 4.9pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="505"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 73pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="97"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 88pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="117"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 120pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="160"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 98pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="1215346.375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="1215346.375" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="48.30789093428136" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="696152.4375" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="1911498.8125" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="75.978731705402367" valign="bottom" width="131"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 73pt; height: 12.75pt;" x:num="" valign="bottom" width="97"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 88pt; height: 12.75pt;" x:num="604335.25" valign="bottom" width="117"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 120pt; height: 12.75pt;" x:num="2515834.0625" valign="bottom" width="160"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 98pt; height: 12.75pt;" x:num="" valign="bottom" width="131"> </td> </tr> </tbody></table>
I am hoping that someone can help me with my issue.
I have posted an example of my data below in "FIG 1".
I would like to create formulas in columns C & D that will change when I filter on the "Division". (i.e. FIG 2) It is also possible that I might want to filter on another column such as column E (not shown), so the formula can't be based on column A.
Basically, I want the formula in column C to cume the dollars in column B not matter how I filter the data (same for column D).
Hope this makes sense. Thanks, Zep
FIG 1
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Ckembd25%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 379pt; margin-left: 4.9pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="505"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 73pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="97">
DIVISION<o></o>
Dollar Sales<o></o>
Dollar Sales Cume<o></o>
$ Share Cume<o></o>
1<o></o>
$1,215,346<o></o>
$1,215,346<o></o>
6.06<o></o>
2<o></o>
$1,213,988<o></o>
$2,429,335<o></o>
12.11<o></o>
3<o></o>
$1,090,495<o></o>
$3,519,830<o></o>
17.55<o></o>
4<o></o>
$988,801<o></o>
$4,508,630<o></o>
22.48<o></o>
5<o></o>
$983,856<o></o>
$5,492,486<o></o>
27.39<o></o>
6<o></o>
$973,895<o></o>
$6,466,381<o></o>
32.25<o></o>
7<o></o>
$922,474<o></o>
$7,388,855<o></o>
36.85<o></o>
8<o></o>
$823,415<o></o>
$8,212,270<o></o>
40.95<o></o>
9<o></o>
$737,272<o></o>
$8,949,542<o></o>
44.63<o></o>
1<o></o>
$696,152<o></o>
$9,645,694<o></o>
48.10<o></o>
2<o></o>
$695,703<o></o>
$10,341,397<o></o>
51.57<o></o>
3<o></o>
$694,632<o></o>
$11,036,029<o></o>
55.03<o></o>
4<o></o>
$670,833<o></o>
$11,706,862<o></o>
58.38<o></o>
5<o></o>
$653,263<o></o>
$12,360,125<o></o>
61.64<o></o>
6<o></o>
$649,721<o></o>
$13,009,846<o></o>
64.88<o></o>
7<o></o>
$641,409<o></o>
$13,651,255<o></o>
68.08<o></o>
8<o></o>
$631,476<o></o>
$14,282,731<o></o>
71.22<o></o>
9<o></o>
$628,807<o></o>
$14,911,538<o></o>
74.36<o></o>
1<o></o>
$604,335<o></o>
$15,515,874<o></o>
77.37<o></o>
2<o></o>
$594,264<o></o>
$16,110,137<o></o>
80.34<o></o>
3<o></o>
$581,242<o></o>
$16,691,379<o></o>
83.24<o></o>
4<o></o>
$570,439<o></o>
$17,261,818<o></o>
86.08<o></o>
5<o></o>
$564,287<o></o>
$17,826,105<o></o>
88.89<o></o>
6<o></o>
$560,156<o></o>
$18,386,261<o></o>
91.69<o></o>
7<o></o>
$559,713<o></o>
$18,945,974<o></o>
94.48<o></o>
8<o></o>
$555,504<o></o>
$19,501,477<o></o>
97.25<o></o>
9<o></o>
$551,554<o></o>
$20,053,031<o></o>
100.00<o></o>
FIG 2
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Ckembd25%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 379pt; margin-left: 4.9pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="505"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; background: silver none repeat scroll 0% 0%; width: 73pt; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; height: 12.75pt;" width="97">
DIVISION<o></o>
Dollar Sales<o></o>
Dollar Sales Cume<o></o>
$ Share Cume<o></o>
1<o></o>
$1,215,346<o></o>
$1,215,346<o></o>
48.31<o></o>
1<o></o>
$696,152<o></o>
$1,911,499<o></o>
75.98<o></o>
1<o></o>
$604,335<o></o>
$2,515,834<o></o>
100.00<o></o>