List of transactions with part numbers into one monthly total

[thepartydj]

Looking for help on a formula
Sheet 1 has a list of 3000+ transactions. Column A has "date", Column F has "Part Number", Column H has "Quantity"
Sheet 2 has the totals that need to be filled in. Column A has "Part Number", Column C, row one has "January", Feb, etc.

I would like to know how many quantity the part number is taken out in each month.

Is that enough info to help me out? I know I need a lookup/reference formula in each month for each part number, but not sure how to do that.

Thanks in advance for the help.

 

[DanteAmor]

Try this

<table style="font-family:Arial; font-size:12pt; border-style: groove ;border-color:#0000FF;background-color:#fffcf9; color:#000000; "><tr><td ><b>Sheet1</b></td></tr></table>
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:47.52px;" /><col style="width:131.17px;" /><col style="width:66.53px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >F</td><td >H</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >DATE</td><td >PART NUMBER</td><td >QUANTITY</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">01-ene</td><td >num1</td><td style="text-align:right; ">35</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">02-ene</td><td >num1</td><td style="text-align:right; ">42</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">10-feb</td><td >num1</td><td style="text-align:right; ">49</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">15-mar</td><td >num1</td><td style="text-align:right; ">56</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">15-ene</td><td >num2</td><td style="text-align:right; ">63</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">20-feb</td><td >num2</td><td style="text-align:right; ">70</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">10-mar</td><td >num3</td><td style="text-align:right; ">85</td></tr></table>

-----------------------------
This is assuming that on sheet2 you have the text of the months January, February, March, etc.

<table style="font-family:Arial; font-size:12pt; border-style: groove ;border-color:#0000FF;background-color:#fffcf9; color:#000000; "><tr><td ><b>Sheet2</b></td></tr></table>
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:118.81px;" /><col style="width:19.96px;" /><col style="width:40.87px;" /><col style="width:53.23px;" /><col style="width:42.77px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >PART NUMBER</td><td > </td><td >January</td><td >February</td><td >March</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >num1</td><td > </td><td style="text-align:right; ">77</td><td style="text-align:right; ">49</td><td style="text-align:right; ">56</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >num2</td><td > </td><td style="text-align:right; ">63</td><td style="text-align:right; ">70</td><td style="text-align:right; ">0</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >num3</td><td > </td><td style="text-align:right; ">0</td><td style="text-align:right; ">0</td><td style="text-align:right; ">85</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=SUMPRODUCT((TEXT(Sheet1!$A$2:$A$8,"mmmm")=C$1)*(Sheet1!$F$2:$F$8=$A2)*(Sheet1!$H$2:$H$8))</td></tr></table></td></tr></table>