Giving a Numerical value to letters

R

Rick

I want to give a value of 1 to Y and C in a worksheet. I don't want the value
to be shown but I want to be able to use the SUM function on the values.

Thanks for the help
 
J

Jason Morin

Assuming that you're summing col. A:

=SUM(A:A,COUNTIF(A:A,{"Y","C"}))

HTH
Jason
Atlanta, GA
 
G

Govind

Hi Jason,

Need a clarification.

Won't just =COUNTIF(A:A,{"Y","C"}) do ?

What is the application of sum function in your formula ?

Regards

Govind.
 
B

Bob Phillips

Try it and see!

--

HTH

RP

Govind said:
Hi Jason,

Need a clarification.

Won't just =COUNTIF(A:A,{"Y","C"}) do ?

What is the application of sum function in your formula ?

Regards

Govind.
Click to expand...
 
R

Rick

Thanks, will give it a try

Govind said:
Hi Jason,

Need a clarification.

Won't just =COUNTIF(A:A,{"Y","C"}) do ?

What is the application of sum function in your formula ?

Regards

Govind.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Calculate the median value before a specified list 0
Finding asymptote equation and how to draw them in excel 0
Drop down list control value in vba 2
Newbie Help - IF Yes No Function 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Sum Values from different column 1

Top