| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Texts in Cells
I have a list of parts numbers (alphabetical and numeric) and want to use
these in a sum. How can I include these in a sum eg if C1= EV1, C2=EV2? Alternatively if not possible can I use the SUBSTITUTE function to pick this text from a list Thanks in advance |
|
#2
|
|||
|
|||
|
do you wnat to do a sum or a count?
if a count, check the countif() function in help "Duncan" wrote: I have a list of parts numbers (alphabetical and numeric) and want to use these in a sum. How can I include these in a sum eg if C1= EV1, C2=EV2? Alternatively if not possible can I use the SUBSTITUTE function to pick this text from a list Thanks in advance |
|
#3
|
|||
|
|||
|
I want to show the text:
eg the column looks like; o o EV-R4 0 0 So I want the cell below to show the text, so I can use it in a product selection guide Thanks "bj" wrote: do you wnat to do a sum or a count? if a count, check the countif() function in help "Duncan" wrote: I have a list of parts numbers (alphabetical and numeric) and want to use these in a sum. How can I include these in a sum eg if C1= EV1, C2=EV2? Alternatively if not possible can I use the SUBSTITUTE function to pick this text from a list Thanks in advance |
|
#4
|
|||
|
|||
|
most of the time people would call this concatinating rather than summing
if C1= EV1, C2=EV2 =C1 & "-" & C2 or = Concatinate(C1,"-",C2) would result in EV1-EV2 "Duncan" wrote: I want to show the text: eg the column looks like; o o EV-R4 0 0 So I want the cell below to show the text, so I can use it in a product selection guide Thanks "bj" wrote: do you wnat to do a sum or a count? if a count, check the countif() function in help "Duncan" wrote: I have a list of parts numbers (alphabetical and numeric) and want to use these in a sum. How can I include these in a sum eg if C1= EV1, C2=EV2? Alternatively if not possible can I use the SUBSTITUTE function to pick this text from a list Thanks in advance |
|
#5
|
|||
|
|||
|
Thanks I have done it
"bj" wrote: most of the time people would call this concatinating rather than summing if C1= EV1, C2=EV2 =C1 & "-" & C2 or = Concatinate(C1,"-",C2) would result in EV1-EV2 "Duncan" wrote: I want to show the text: eg the column looks like; o o EV-R4 0 0 So I want the cell below to show the text, so I can use it in a product selection guide Thanks "bj" wrote: do you wnat to do a sum or a count? if a count, check the countif() function in help "Duncan" wrote: I have a list of parts numbers (alphabetical and numeric) and want to use these in a sum. How can I include these in a sum eg if C1= EV1, C2=EV2? Alternatively if not possible can I use the SUBSTITUTE function to pick this text from a list Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
