Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with text
If I have text instead of numbers - what formula would I use that works like
SUMIF. Example: On sh2 I want to copy text in B? where A? has the value of "Cotton" to sh1 C32. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with text
Do you mean that you want to join all the text values together to make
one long string? Do you want spaces or some other delimiter between each text item? How many rows are you using on sh2? Pete On May 6, 5:38*am, bgkgmg wrote: If I have text instead of numbers - what formula would I use that works like SUMIF. Example: On sh2 I want to copy text in B? where A? has the value of "Cotton" to sh1 C32. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF for Text | Excel Discussion (Misc queries) | |||
Sumif vs Text? | Excel Worksheet Functions | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
sumif with text? | Excel Discussion (Misc queries) | |||
SUMIF exluding text | Excel Worksheet Functions |