Sumproduce nested with Countif

[mkalawa]

I am so close but yet so far away.... ok-

A B C D E F

20141219-DE-IT-0001	tng	greece	bread	man	19.11.2014
20141217-DE-FB-0001	tng	greece	bread	woman	16.12.2014
20141219-DE-FB-0002	tng	greece	bread	boy	19.12.2014
20150319-VDB-RRR-FB-0002	tng	greeced	bread	girl	23.03.2015

<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

.
.
.

SUMPRODUCT(--(IKS_Zentral!$F$9:$F$1000<>"");--(MONTH(IKS_Zentral!$F$9:$F$1000)=11);--(YEAR(IKS_Zentral!$F$9:$F$1000)=2014))

the above formular produces this result:

November, 2014	1
December, 2014	3
January, 2015	0
February, 2015	0

<colgroup><col><col></colgroup><tbody>
</tbody>

...

However, I want to select from a range (IKS_Zentral!$A$9:$F$1000) where each cell contains a specific string. meaning i only want to sum a range A:A that contain a specific string.... (IT),

I wrote the below formular but I am receiving a #VALUE error message: =SUMPRODUCT(COUNTIF(IKS_Zentral!A9:A1000;"*IT*");--(IKS_Zentral!$F$9:$F$1000<>"");--(MONTH(IKS_Zentral!$F$9:$F$1000)=11);--(YEAR(IKS_Zentral!$F$9:$F$1000)=2014))

Your expertise is highly appreciated.

 

[123rickfear]

=COUNTIFS(H:H,2014,G:G,11,A:A,"*IT*")

in column G I did =month(F:F) and in H =year(F:F)

 

[Jonmo1]

Without the helper columns to extract month and year..

=COUNTIFS(F:F,">="&DATE(2014,11,1),F:F,"<="&DATE(2014,11,30),A:A,"*IT*")

 

[mkalawa]

Without the helper columns to extract month and year..

=COUNTIFS(F:F,">="&DATE(2014,11,1),F:F,"<="&DATE(2014,11,30),A:A,"*IT*")

Jonmo1 thanks a lot, very clean... appreciate the support.

 

[Jonmo1]

You're welcome.