You can shorten the formula a bit by using ISNUMBER instead of NOT(ISNA(...))
and by moving the multiplication inside the sumproduct formula (which
eliminates the need for the --), i.e.

=SUMPRODUCT(7.75*ISNUMBER(MATCH(E8:H8,{"LA";"PD";" EA";"PDX";"MC";"V";"PR"},0)))+
4.75*(ISNUMBER(MATCH(I8,{"LA";"PD";"EA";"PDX";"MC" ;"V";"PR"},0)))

Or, IF none of the cells E8:H8 will ever be blank,

=SUMPRODUCT(7.75*ISNUMBER(FIND(E8:H8,"LA/PD/EA/PDX/MC/V/PR")))+4.75*ISNUMBER(FIND(I8,"LA/PD/EA/PDX/MC/V/PR"))

On 9 Feb 2005 08:23:35 -0800, "Tourcat" wrote:

Thanks that worked great, but what about the following situation. What
if, for example, cells E8:H8 were multiplied by 7.75 and cell I8 needed
to be multiplied by 4.75, can both be combined into one function for
one cell. Here is what I have for cell J8 so far, for example:

=7.75*SUMPRODUCT(--NOT(ISNA(MATCH(E8:H8,{"LA";"PD";"EA";"PDX";"MC";"V ";"PR

"},0))))

I need cell I8 to be included above, but the SUMPRODUCT would need to
be multiplied by 4.75 just for that one cell. Any suggestions? Thanks.