=SUMPRODUCT(--(MONTH('Short Term Issues'!$A$2:$A$100)=11),--(YEAR('Short Term Issues'!$A$2:$A$100)=2010),--('Short Term Issues'!$D$2:$D$100="Leaking"))
Im using the above formula to count rows which have the information 'Leaking' contained in column D:D where the date raised in column A:A is within a certain month, in this case 'Nov2010' - Ill be duplicating the formula for subsequent months, and differant key words in other cells
My problem is that this formula only counts cells which are an exact match of the keyword. Can this be modified so that it counts cells where other words are present along with the keyword?? I have tried using a wildcard type function but iv been unsuccessful so far.
Any helps is appreciated, Thanks
Bookmarks