How to sum ONLY text?

  • Thread starter Thread starter ExhalE
  • Start date Start date
E

ExhalE

Hi.

I've got a worksheet here with alot of names, timetable. How do i sum names
without the value coming out as "0" ?
 
Yes. COUNTA()
Thanks for pointing that out...

Luke M said:
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!*
Click to expand...
 
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?
 
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.
 
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?
 
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
 
Back
Top