T. Valko, your an absolute magician,

thank you.

"T. Valko" wrote:

Try this:

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

Or, maybe this:

=IFERROR(SUMIF(B6:B33,"*DEF",K6:K33)/COUNTIFS(B6:B33,"*DEF",K6:K33,"0"),"-")

--
Biff
Microsoft Excel MVP


"Anto111" wrote in message
...
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