Hi guys,

I am currently applying the following formula to a speadsheet:

=IFERROR(SUMPRODUCT(--(B6:B33="F DEF"),K6:K33)/SUMPRODUCT(--(B6:B33="F
DEF"),--(K6:K330)),"-")

In a seperate formula I have also replaced "F DEF" with "C DEF" to return a
different value. What I would now like to do is create a similar formula that
incorparates both sets of data into one formula by identifying only the last
three letters, i.e "DEF".

Any ideas would be greatly appreciated.

Thanks in advance,

Ant