A
Anto111
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:K33>0)),"-")
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
I am currently applying the following formula to a speadsheet:
=IFERROR(SUMPRODUCT(--(B6:B33="F DEF"),K6:K33)/SUMPRODUCT(--(B6:B33="F
DEF"),--(K6:K33>0)),"-")
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