Trying to duplicate a cell of text into another work sheet only if the result
in a particular cell is "yes". I can do it with the SUMIF formular i.e

=SUM(SUMIF('Quotes Generated'!L9,"YES",'Quotes Generated'!C9))

But it's not the sum of numbers I'm after, because the cell contains text,
the answer is resulted as 0.