| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a letter to a numeric value
I have a spreadsheet where I need to tally the number of Yes, No and N/A
anwsers. How can I add them if the letter "x" is being used to mark the answer? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a letter to a numeric value
Assuming you have 3 columns for Yes, No and N/A and they are putting an X in
the relevant column, you can use the countif function for each columns range e.g. =COUNTIF(A1:A500,"x") =COUNTIF(B1:B500,"x") =COUNTIF(C1:C500,"x") "Jcdc" wrote: I have a spreadsheet where I need to tally the number of Yes, No and N/A anwsers. How can I add them if the letter "x" is being used to mark the answer? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a letter to a numeric value
=COUNTIF(A1:A100,"x")
Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 08:33:01 -0700, Jcdc wrote: I have a spreadsheet where I need to tally the number of Yes, No and N/A anwsers. How can I add them if the letter "x" is being used to mark the answer? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a letter to a numeric value
Assume that your YES, NO and N/A values are in A Column from A1 to A100
and the marking text X in B column from B1 to B100. Count Number of Yes From A1 to A100 =SUMPRODUCT((A1:A100="YES")*(B1:B100="X")) Count Number of NO From A1 to A100 =SUMPRODUCT((A1:A100="NO")*(B1:B100="X")) Count Number of N/A From A1 to A100 =SUMPRODUCT((A1:A100="N/A")*(B1:B100="X")) To get all the above in one instance try the below one. =SUMPRODUCT((A1:A100="YES")*(B1:B100="X"))&" YES - "&SUMPRODUCT((A1:A100="NO")*(B1:B100="X"))&" NO - "&SUMPRODUCT((A1:A100="N/A")*(B1:B100="X"))&" N/A" Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Jcdc" wrote: I have a spreadsheet where I need to tally the number of Yes, No and N/A anwsers. How can I add them if the letter "x" is being used to mark the answer? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting a letter to a numeric value
The COUNTIF function can do this. E.g,.
=COUNTIF(A1:A10,"x") will return the number of "x" entries in the range A1:A10. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Thu, 15 Apr 2010 08:33:01 -0700, Jcdc wrote: I have a spreadsheet where I need to tally the number of Yes, No and N/A anwsers. How can I add them if the letter "x" is being used to mark the answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting RIC1 code to letter Column/Numeric Row | Excel Discussion (Misc queries) | |||
| How do I assign a numeric value to a letter | Excel Worksheet Functions | |||
| Convert a letter to a numeric value | Excel Worksheet Functions | |||
| Converting Letter to Numeric Value | Excel Worksheet Functions | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
Linear Mode
