Sumproduct within the same column

I am trying to search through a string for specific words and if both words match then have it count. It would work best if COUNTIF could handle multiple conditions but at the moment I am trying to use SUMPRODUCT. The problem is is that I am not sure if one can use SUMPRODUCT with both arrays being the same column. This is what I have so far and it does't seem to work.

=SUMPRODUCT(--(G2:G300="*WebCT*"),--(G2:G300="*quiz*"))

For it to count, both WebCT and quiz must be found in the string.
I have also tried it without the -- and using * instead of , but with the same results (nothing )

Also, is there a way to ignore the case-sensitive search?

Thanks for any help.

Works like a charm! Thanks very much.


Colton

___________

"Kids, you tried your best and you failed miserably. The lesson is, never try."