| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - SUMIF but with a text not number result?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas - SUMIF but with a text not number result?
=IF('Quotes Generated'!L9="YES",'Quotes Generated'!C9,"")
"Lindy" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif where cells contain Number & Text | Excel Discussion (Misc queries) | |||
| How make text appear in a cell as a result of a number in another | Excel Discussion (Misc queries) | |||
| sumif wrong result | Excel Worksheet Functions | |||
| Is it possible to have a 3D sumif result? | Excel Discussion (Misc queries) | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
Linear Mode
