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

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

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

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

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