Counting Inventory Quantity formula help.

Place a list of months in your workbook somewhere...

January
February
March
April
May
June
July
August
September
October
November
December

Name the range "month" (without the quotes; scope workbook)....

Then place this formula in Master Inventory H2 and copy down...

=SUMPRODUCT(SUMIF(INDIRECT(month&"[Item]"),B2,INDIRECT(month&"[Quantity]")))

ETA: being H2 is in a Table and all the existing formulas in column H are same, the Table should automatically copy the formula down the column.