Hi!

So, you want the total of ALL entries that match the the variables?

Make a list of those variables:

F1:F6 =

HAC4
HHP4
HXA4
HXA2
HXH2
H9MPV


Then:

=SUMPRODUCT(--(ISNUMBER(SEARCH(F1:F6,A1:A9))),B1:B9)*40

Biff

"Corey Osborn" <Corey Osborn@discussions.microsoft.com> wrote in message
news:11C13388-32BB-4A0A-B07B-40E2D2728E62@microsoft.com...
>I have 2 columns:
>
> Model qty
> HAC4##### 1
> HHP4##### 2
> HXA4##### 1
> HXA2##### 3
> HXH2##### 3
> H9MPV#### 4
> chair 1
> toys 1
> benchmark 1
>
> HAC4, HHP4, HXA4, HXA2, HXH2, & H9MPV are the common identifiers that I am
> looking for. I would like to write an equations that looks for these
> common
> identifiers and muliplies 40 x the QTY column.
>