adding third criteria to an existing equation

[joachim25]

I have an existing equation

=SUMPRODUCT((kshc2012=A6)*(kfshcol1=1))

and I want to add to that equation to include another criteria where it will only count months "January and February" from the same name range

 

[Asala42]

Sure, assuming the range "kfshcol1" contains dates you can use:

=SUMPRODUCT((kshc2012=A6)*(kfshcol1=1)*(Month(kfshcol1)<=2))