SUMPRODUCT with Wildcard

[jstevens]

Is it possible to use a wildcard with the SUMPRODUCT formula or an equivalent formula?

I have attached a sample workbook.

EL_TestMonth.xlsx

[HansV]

No, but you can use the LEFT function: change G13 to 6 (as a text value, so prefixed by an apostrophe), and change the SUMPRODUCT formula to

=SUMPRODUCT((MONTH(A$2:A$8)>=1)*(MONTH(A$2:A$8)<=R_Summary_Month)*(YEAR(A$2:A$8)=2016)*(LEFT(B$2:B$8,1)=G13)*C$2:C$8)

[jstevens]

Hans,

Thank you!