one other possibility:

=SUMPRODUCT(--('raw data'!K1:K10="A"),--(NOT(ISERROR(SEARCH("Latitude",'raw
data'!L1:L10,1)0))))

FYI - I believe Ron and Pinmaster pointed out the sumproduct cannot work
with an entire column so K:K will not work, but K1:K65535 will.


"msbutton27" wrote:

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...