| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sum ONLY text?
Hi.
I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum ONLY text?
If you mean count the names use the COUNT() function
If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi. I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum ONLY text?
Jacob, I think you meant COUNTA(), as COUNT does not recognize text.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jacob Skaria" wrote: If you mean count the names use the COUNT() function If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi. I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum ONLY text?
Yes. COUNTA()
Thanks for pointing that out... "Luke M" wrote: Jacob, I think you meant COUNTA(), as COUNT does not recognize text. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jacob Skaria" wrote: If you mean count the names use the COUNT() function If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi. I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum ONLY text?
Didnt work, it just counts the cells that arent empty.
I want them to count how many times a given name appear in, say 10 cells. A B C 1 John Smith Karen 2 Paul John Bill 3 Bill Karen Bill Would like that to come out as: John: 2 Paul: 1 Bill: 3 Smith: 1 etc. So get it to somehow pick up =COUNTA("Bill") Know what i mean? "Jacob Skaria" wrote: Yes. COUNTA() Thanks for pointing that out... "Luke M" wrote: Jacob, I think you meant COUNTA(), as COUNT does not recognize text. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jacob Skaria" wrote: If you mean count the names use the COUNT() function If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi. I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sum ONLY text?
Take a look at the COUNTIF function then. either
=COUNTIF(A1:C1,"John") or possibly =COUNTIF($A$1:$C$1,F1) If F1 contains the name "John", in a list, and you could then copy the formula over/down as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ExhalE" wrote: Didnt work, it just counts the cells that arent empty. I want them to count how many times a given name appear in, say 10 cells. A B C 1 John Smith Karen 2 Paul John Bill 3 Bill Karen Bill Would like that to come out as: John: 2 Paul: 1 Bill: 3 Smith: 1 etc. So get it to somehow pick up =COUNTA("Bill") Know what i mean? "Jacob Skaria" wrote: Yes. COUNTA() Thanks for pointing that out... "Luke M" wrote: Jacob, I think you meant COUNTA(), as COUNT does not recognize text. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jacob Skaria" wrote: If you mean count the names use the COUNT() function If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi. I've got a worksheet here with alot of names, timetable. How do i sum names without the value coming out as "0" ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Hybrid Mode
