Combine adding numbers and color formatting

Memar

Board Regular
Joined
Sep 2, 2011
Messages
76
[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]
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
[TABLE="width: 1216"]
<colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Month[/TD]
[TD="width: 64"]Region[/TD]
[TD="width: 64"]Location[/TD]
[TD="width: 64"]Amount[/TD]
[TD="width: 64"]Product[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Jul-18[/TD]
[TD]East[/TD]
[TD]Branch 1[/TD]
[TD="align: right"]700.02[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Jul-18[/TD]
[TD]WEST[/TD]
[TD]Branch 2[/TD]
[TD="class: xl22, align: right"]1,596.90[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Jul-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD="class: xl22, align: right"]2,160.30[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]date[/TD]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Jul-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 4[/TD]
[TD="align: right"]223.08[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]location[/TD]
[TD]Branch 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Jul-18[/TD]
[TD]East[/TD]
[TD]Branch 5[/TD]
[TD="align: right"]842.7[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]product[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD="class: xl22, align: right"]4,330.61[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]region[/TD]
[TD]East[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD="align: right"]741.78[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD="align: right"]64.45[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD="class: xl22, align: right"]2,139.30[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3065.61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD="class: xl22, align: right"]1,131.04[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]East[/TD]
[TD]Branch 1[/TD]
[TD="align: right"]293.85[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD="class: xl22, align: right"]1,469.25[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 11"]=SUMPRODUCT(($A$2:$A$31=$K$4)*($B$2:$B$31=$K$7)*($C$2:$C$31=$K$5)*($E$2:$E$31=$K$6)*($D$2:$D$31))[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD="class: xl22, align: right"]1,312.52[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD="class: xl22, align: right"]5,133.76[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Aug-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD="align: right"]984.39[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]East[/TD]
[TD]Branch 1[/TD]
[TD="class: xl22, align: right"]1,643.71[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 2[/TD]
[TD="align: right"]795.9[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 3[/TD]
[TD="class: xl22, align: right"]1,349.63[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD="class: xl22, align: right"]1,282.70[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 7"]if you change any or all of the 4 variables you will get the desired total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD="align: right"]32.23[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 1[/TD]
[TD="align: right"]145[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD="class: xl22, align: right"]1,833.77[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]East[/TD]
[TD]Branch 3[/TD]
[TD="align: right"]721.89[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 4[/TD]
[TD="align: right"]227.4[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]NORTH[/TD]
[TD]Branch 5[/TD]
[TD="class: xl22, align: right"]1,399.48[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]East[/TD]
[TD]Branch 1[/TD]
[TD="class: xl22, align: right"]1,421.90[/TD]
[TD]Product 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 2[/TD]
[TD="class: xl22, align: right"]1,904.85[/TD]
[TD]Product 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]WEST[/TD]
[TD]Branch 3[/TD]
[TD="class: xl22, align: right"]3,835.31[/TD]
[TD]Product 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]WEST[/TD]
[TD]Branch 4[/TD]
[TD="class: xl22, align: right"]2,207.06[/TD]
[TD]Product 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23, align: right"]1-Sep-18[/TD]
[TD]SOUTH[/TD]
[TD]Branch 5[/TD]
[TD="align: right"]175.01[/TD]
[TD]Product 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top