I am trying to use countifs for the following:

Count how many times a single letter “T” (column 1) occurs within the date range from 1/1/14 to 1/31/14 (column 2) it works fine until here.


However I have errors when I try to incorporate the following:

Not able to count occurrences of the column 3 that has part of a word (*karu) and blank cells within the same column.
Also add one if the last column has a number or do not count if is blank.


=COUNTIFS('sheet1'!$F:$F,"T",sheet1'!$E:$E,"TP",sh eet1'!$L:$L,"*KARU",sheet1'!$A:$A,">=1/1/14",sheet1'!$A:$A,"<=1/31/14")+COUNTIFS(sheet1'!$F:$F,"T",sheet1'!$E:$E,"TP" ,sheet1'!$L:$L,"",sheet1'!$P:$P,"<>3",sheet1'!$A:$ A,">=1/1/14",sheet1'!$A:$A,"<=1/31/14")

I think the problem start after the plus sign, but not sure how to concatenate another formula to do the task.

I appreciate if someone help me with this.