| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what if the result of a formula is text
I'm looking for a formula like "sumif" but the result of the formula is text.
If a range matches a single cell the result is text. What do I use |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what if the result of a formula is text
SUMIF usually sums values in one range dependant on values in another, obviously you can't sum text. are you looking to count the matches, in which case use COUNTIF or if you're looking for one match perhaps VLOOKUP. If you give a more specific example you can get some more specific help :) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515255 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Adding text to the result of a formula? | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Hybrid Mode
