|
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" ? |
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" ? |
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" ? |
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" ? |
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" ? |
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" ? |
How to sum ONLY text?
Hi Luke!
Thank you. The first one worked out great. But i didnt get the second one to work. Just came out "0" =COUNTIF($B$5:$F$7;H5) H5 being John Any ideas? "Luke M" wrote: 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" ? |
How to sum ONLY text?
Check whether the exact entry in H5 is present in your range...(even spaces
count) =COUNTIF($B$5:$F$7,TRIM(H5)) If this post helps click Yes --------------- Jacob Skaria "ExhalE" wrote: Hi Luke! Thank you. The first one worked out great. But i didnt get the second one to work. Just came out "0" =COUNTIF($B$5:$F$7;H5) H5 being John Any ideas? "Luke M" wrote: 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" ? |
| All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com