| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you calculate text into numerical answers?
in excel 2003 and I am trying to get a sum of textual data that is the same.
For example If i have monday listed 5 times in the same column amongst the other days of the week, i want a function that allows me to add the mondays up and give me the number 5. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you calculate text into numerical answers?
That's called a count, not a sum.
Look in HELP for the COUNTIF() function -- Kind regards, Niek Otten Microsoft MVP - Excel "tyler8" wrote in message ... | in excel 2003 and I am trying to get a sum of textual data that is the same. | For example If i have monday listed 5 times in the same column amongst the | other days of the week, i want a function that allows me to add the mondays | up and give me the number 5. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you calculate text into numerical answers?
Try this:
=COUNTIF(A1:A20,"Monday") Biff "tyler8" wrote in message ... in excel 2003 and I am trying to get a sum of textual data that is the same. For example If i have monday listed 5 times in the same column amongst the other days of the week, i want a function that allows me to add the mondays up and give me the number 5. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you calculate text into numerical answers?
How about this...
=COUNTIF(A:A, "=Monday") -- HTH... Jim Thomlinson "tyler8" wrote: in excel 2003 and I am trying to get a sum of textual data that is the same. For example If i have monday listed 5 times in the same column amongst the other days of the week, i want a function that allows me to add the mondays up and give me the number 5. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you calculate text into numerical answers?
Thank you guys for all of your help. It worked out perfectly!!!!!
"tyler8" wrote: in excel 2003 and I am trying to get a sum of textual data that is the same. For example If i have monday listed 5 times in the same column amongst the other days of the week, i want a function that allows me to add the mondays up and give me the number 5. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
