Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
I want the ability to search a range of cells on a separate tab but instead
of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
You probably want Vlookup. There's a good explanation in Help. Post back if
you need more. Regards, Fred. "bazsil,73" wrote in message ... I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You send a clear explanation of what you want 3. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "bazsil,73" wrote in message ... I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
It sounds like you want to use =vlookup() or =index(match()).
Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble bazsil,73 wrote: I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
Home Place a
South Place b Chuck c Janie d Eighty e Ansutz f Riggin North g Riggin South h Rowe i Booth j Flora k Extra 2 l Extra 3 m Extra 4 n "bazsil,73" wrote: I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
It is still not clear what you want??
-- Don Guillett Microsoft MVP Excel SalesAid Software "bazsil,73" wrote in message ... Home Place a South Place b Chuck c Janie d Eighty e Ansutz f Riggin North g Riggin South h Rowe i Booth j Flora k Extra 2 l Extra 3 m Extra 4 n "bazsil,73" wrote: I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for text
The VLOOKUP achieved what I needed. Thanks.!
"bazsil,73" wrote: I want the ability to search a range of cells on a separate tab but instead of calculating the sum range I want it to enter the text in that range. Each cell in the range will contain unique text (names) and there will be no duplicates. What I think I need is an if function that works similar to the sumif function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif - if the text has LCI in it | Excel Worksheet Functions | |||
SUMIF with text | Excel Worksheet Functions | |||
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) |