Have to worksheets, one with a bunch of raw data and the other where I am
performing my calculations.

Therefore in RAW DATA sheet I have 2 columns that look like this

Column A Column B
A Latitude
B Compaq
A Gateway
C GX250
A Gateway
B Latitude
A GX270
C Compaq

So I want to perform a calculation that:
If Column A equals A, then count all the Compaq's
If Column A equals A, then count allthe GX270
And so forth, basically depending on Column A I need to count words
instances in column B.

Column B, does not always contian the exact word, sometimes it may say
Latitude C610, or C620 - therefore want to count the instances of the word
"Latitude" no matter what version...

I was trying to use this:

=SUMPRODUCT(('--(Raw Data'!K:K=A)),(--('Raw Data'!L:L="Latitude")))
but of course does not work - any thoughts...