I have values in Sheet 1 columns A-M. Column K contains the quantity purchased and column L contains Total Extended cost for a value (alpha numeric description) in column D. I am trying to sum the values in column K as well as values in column L and return based on the matching alpha numeric description in column D. I want the results in sheet 2 with. The data on all columns in a row are the same with the exception of K and L which I want to sum. I pasted some example data below since I cannot upload a file. Any help will be appreciated</SPAN>
<TBODY>
</TBODY><COLGROUP><COL span=3><COL><COL span=8></COLGROUP>
Division Name</SPAN> | AHFS Therapeutic Code</SPAN> | NDC Current Code</SPAN> | RX Item Desc</SPAN> | Generic Code Num</SPAN> | Generic Seq Num</SPAN> | Route Of Admin Code</SPAN> | Dosage Form Desc</SPAN> | Label Name</SPAN> | Qty</SPAN> | Total Extended Cost Amt - Sum</SPAN> | Package Size</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00093030801</SPAN> | CLEMASTIN FUM 100 2.68</SPAN> | 46691</SPAN> | 011656</SPAN> | PO</SPAN> | TABLET </SPAN> | CLEMASTINE FUMARATE </SPAN> | 1.00</SPAN> | 12.40</SPAN> | 100.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00093030801</SPAN> | CLEMASTIN FUM 100 2.68</SPAN> | 46691</SPAN> | 011656</SPAN> | PO</SPAN> | TABLET </SPAN> | CLEMASTINE FUMARATE </SPAN> | -1.00</SPAN> | -8.06</SPAN> | 100.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00093030912</SPAN> | CLEMASTIN FUM 4 OZ 0.67</SPAN> | 46990</SPAN> | 011654</SPAN> | PO</SPAN> | SYRUP </SPAN> | CLEMASTINE FUMARATE </SPAN> | 2.00</SPAN> | 24.96</SPAN> | 120.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00121048905</SPAN> | DIPHENHYD 100X5 ML 12.5</SPAN> | 46032</SPAN> | 011592</SPAN> | PO</SPAN> | ELIXIR </SPAN> | DIPHENHYDRAMINE HCL </SPAN> | 1.00</SPAN> | 40.94</SPAN> | 5.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00121048905</SPAN> | DIPHENHYD 100X5 ML 12.5</SPAN> | 46032</SPAN> | 011592</SPAN> | PO</SPAN> | ELIXIR </SPAN> | DIPHENHYDRAMINE HCL </SPAN> | 1.00</SPAN> | 40.94</SPAN> | 5.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00121048905</SPAN> | DIPHENHYD 100X5 ML 12.5</SPAN> | 46032</SPAN> | 011592</SPAN> | PO</SPAN> | ELIXIR </SPAN> | DIPHENHYDRAMINE HCL </SPAN> | 1.00</SPAN> | 40.94</SPAN> | 5.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00121048905</SPAN> | DIPHENHYD 100X5 ML 12.5</SPAN> | 46032</SPAN> | 011592</SPAN> | PO</SPAN> | ELIXIR </SPAN> | DIPHENHYDRAMINE HCL </SPAN> | 1.00</SPAN> | 40.94</SPAN> | 5.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00603082381</SPAN> | Q-DRYL A/F 8 OZ 12.5</SPAN> | 48831</SPAN> | 016675</SPAN> | PO</SPAN> | LIQUID </SPAN> | Q-DRYL </SPAN> | 2.00</SPAN> | 2.94</SPAN> | 237.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00603082381</SPAN> | Q-DRYL A/F 8 OZ 12.5</SPAN> | 48831</SPAN> | 016675</SPAN> | PO</SPAN> | LIQUID </SPAN> | Q-DRYL </SPAN> | 2.00</SPAN> | 2.94</SPAN> | 237.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00603082381</SPAN> | Q-DRYL A/F 8 OZ 12.5</SPAN> | 48831</SPAN> | 016675</SPAN> | PO</SPAN> | LIQUID </SPAN> | Q-DRYL </SPAN> | 2.00</SPAN> | 2.94</SPAN> | 237.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00603082381</SPAN> | Q-DRYL A/F 8 OZ 12.5</SPAN> | 48831</SPAN> | 016675</SPAN> | PO</SPAN> | LIQUID </SPAN> | Q-DRYL </SPAN> | 4.00</SPAN> | 5.88</SPAN> | 237.00</SPAN> |
North Pole Division</SPAN> | 040404 - ETHANOLAMINE DERIVATIVES </SPAN> | 00603082381</SPAN> | Q-DRYL A/F 8 OZ 12.5</SPAN> | 48831</SPAN> | 016675</SPAN> | PO</SPAN> | LIQUID </SPAN> | Q-DRYL </SPAN> | 1.00</SPAN> | 1.47</SPAN> | 237.00</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=3><COL><COL span=8></COLGROUP>