| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=COUNTIF(N3:N10016, "YES")&" Sold"
=COUNTIF(N3:N10016, "NO")&" In Stock" Vaya con Dios, Chuck, CABGx3 "Robbie in Houston" wrote in message ... I am curious if there is a way to add text to the result of a formula. For instance, I would like the formulas O1: =COUNTIF(N3:N10016, "YES") P1: =COUNTIF(N3:N10016, "NO") to appear as: O1: 1027 Sold P1: 8987 In Stock without having to type the text in a different cell. Thanks in advance, Robbie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| formula is displaying as text rather than result. | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Hybrid Mode
