Formulas - SUMIF but with a text not number result?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum number range ignoring numbers formatted as text 0
3d array formulas 2
Where to put quotes in a SUMIF formula and when is & used for cell 2
Need help with SUMIF formula 3
SumIf Question 2
Sumif number is greater than a number but less than another number 2
SUMIF for Text 2
Indirect and sumif functions with multiple workbooks 1

Top