Formulas - SUMIF but with a text not number result?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top