I have the following formula:

{=SUM(('Data 2'!D:D>=VALUE("17-September-2012"))*('Data 2'!K:K="0 out of 1"))-SUM(('Data 2'!D:D>="None Specified")*('Data 2'!K:K="0 out of 1"))}

This works fine to count the data which is dated after the 17th september with O out of 1 in column K, however I want to count the number of cells where the contents contain O out of*

However it seems that wildcards are not allowed in loical statements in SUM?

Is there a better way for me to do this?

Thanks