I've got a spreadsheet that looks like this. (The last colum isn't in the sheet yet; what I need help with is getting that colum to be calculated.)<html><table><tr><td>Customer</td><td>Location</td><td>Sales</td><td>Totals</td></tr><tr><td>1</td><td>ABC Co</td><td>Michigan</td><td>50</td><td></td></tr><tr><td>1</td><td>ABC Co</td><td>Michigan</td><td>100</td><td>150</td></tr><tr><td>1</td><td>ABC Co</td><td>Indiana</td><td>25</td><td></td></tr><tr><td>1</td><td>ABC Co</td><td>Indiana</td><td>30</td><td>55</td></tr><tr><td>1</td><td>XYZ Inc</td><td>Indiana</td><td>60</td><td></td></tr><tr><td>1</td><td>XYZ Inc</td><td>Indiana</td><td>80</td><td>140</td></tr><tr><td>1</td><td>XYZ Inc</td><td>Illinois</td><td>90</td><td></td></tr><tr><td>1</td><td>XYZ Inc</td><td>Illinois</td><td>100</td><td>190</td></tr><tr><td>2</td><td>XYZ Inc</td><td>Illinois</td><td>40</td><td></td></tr><tr><td>2</td><td>XYZ Inc</td><td>Illinois</td><td>20</td><td>60</td></tr></table></html>
I need a total amout of sales for each vendor, for each customer, for each location. One customer could have many branches in different locations, but each seperate location needs its own total. How can I calculate this last colum given these restrictions? Any help is greatly appreciated!
EDIT: Fixed the HTML.
This message was edited by tvar on 2002-09-23 14:36
I need a total amout of sales for each vendor, for each customer, for each location. One customer could have many branches in different locations, but each seperate location needs its own total. How can I calculate this last colum given these restrictions? Any help is greatly appreciated!
EDIT: Fixed the HTML.
This message was edited by tvar on 2002-09-23 14:36