Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert text to numbers in excel?
I have a work schedule that shows "D" for working days, and "N" for working
nights. At the end of the month, there is a cell that shows "Total Days/Nights Worked" for that particular month. How do create a formula that says, "If there is a "D" or a "N" in these particular cells, then show a value of "1" for each, and add them up. In other words, if you worked 6 days and 9 nights for the month of January, I'd like for the total to show 15. Thanks a million to anyone who can help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert text to numbers in excel?
Hi there
Number of nights can be determined by =COUNTIF(A1:A10,"N") Number of days by =COUNTIF(A1:A10,"D") thus the total is =COUNTIF(A1:A10,"N")+COUNTIF(A1:A10,"D") "JSM52272" wrote: I have a work schedule that shows "D" for working days, and "N" for working nights. At the end of the month, there is a cell that shows "Total Days/Nights Worked" for that particular month. How do create a formula that says, "If there is a "D" or a "N" in these particular cells, then show a value of "1" for each, and add them up. In other words, if you worked 6 days and 9 nights for the month of January, I'd like for the total to show 15. Thanks a million to anyone who can help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert text to numbers in excel?
=COUNTIF(A:A,"D")
etc. or together =SUM(COUNTIF(A:A,{"D","N"})) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JSM52272" wrote in message ... I have a work schedule that shows "D" for working days, and "N" for working nights. At the end of the month, there is a cell that shows "Total Days/Nights Worked" for that particular month. How do create a formula that says, "If there is a "D" or a "N" in these particular cells, then show a value of "1" for each, and add them up. In other words, if you worked 6 days and 9 nights for the month of January, I'd like for the total to show 15. Thanks a million to anyone who can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I convert numbers to text in Excel? | Excel Worksheet Functions | |||
How do I convert text to numbers in an old version of excel | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
I want to convert numbers to text in Excel | Excel Discussion (Misc queries) |