[h=2]I just want to add a total amount for region East, Branch 1 and product 1 only for the months highlighted in blues. The result is shown in a different workbook (A), but the data/ information is saved in a different workbook (B). I want the result to be shown in workbook A whether workbook B is open or closed.
[TABLE="class: cms_table, width: 0"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Region [/TD]
[TD]Location [/TD]
[TD]Amount[/TD]
[TD]Product [/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]700.02[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]WEST[/TD]
[TD]Branch 2[/TD]
[TD]1,596.90[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]2,160.30[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 4[/TD]
[TD]223.08[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]East [/TD]
[TD]Branch 5[/TD]
[TD]842.70[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD]4,330.61[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]741.78[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]64.45[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]2,139.30[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]1,131.04[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]293.85[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]1,469.25[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]1,312.52[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]5,133.76[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]984.39[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]1,643.71[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]795.90[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 3[/TD]
[TD]1,349.63[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD]1,282.70[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD]32.23[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD]145.00[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD]1,833.77[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 3[/TD]
[TD]721.89[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD]227.40[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD]1,399.48[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]1,421.90[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD]1,904.85[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]3,835.31[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]2,207.06[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]175.01[/TD]
[TD]Product 5[/TD]
[/TR]
</tbody>[/TABLE]
The desired result in this example is $3,065.00
Thank you for your help and time.[/h]
[TABLE="class: cms_table, width: 0"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Region [/TD]
[TD]Location [/TD]
[TD]Amount[/TD]
[TD]Product [/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]700.02[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]WEST[/TD]
[TD]Branch 2[/TD]
[TD]1,596.90[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]2,160.30[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 4[/TD]
[TD]223.08[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]July-18[/TD]
[TD]East [/TD]
[TD]Branch 5[/TD]
[TD]842.70[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD]4,330.61[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]741.78[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]64.45[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]2,139.30[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]1,131.04[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]293.85[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]1,469.25[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]1,312.52[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]5,133.76[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]August-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]984.39[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]1,643.71[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD]795.90[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 3[/TD]
[TD]1,349.63[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD]1,282.70[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD]32.23[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD]145.00[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD]1,833.77[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 3[/TD]
[TD]721.89[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD]227.40[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD]1,399.48[/TD]
[TD]Product 5[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]East [/TD]
[TD]Branch 1[/TD]
[TD]1,421.90[/TD]
[TD]Product 1 [/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD]1,904.85[/TD]
[TD]Product 2[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD]3,835.31[/TD]
[TD]Product 3[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD]2,207.06[/TD]
[TD]Product 4[/TD]
[/TR]
[TR]
[TD]September-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD]175.01[/TD]
[TD]Product 5[/TD]
[/TR]
</tbody>[/TABLE]
The desired result in this example is $3,065.00
Thank you for your help and time.[/h]