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