View Full Version : Using Count to get the number of cells in a column that contain text
K4IE
Dec 3, 2008, 03:38 PM
I'm trying to just count the number of cells in a column that have text in them. I used a formula given in one of the previous questions and got a return of #NUM.
The fomula I tried was =Sumproduct((Callsign <>"")/Count if (Callsign, Callsign & ""))
ScottGem
Dec 3, 2008, 03:42 PM
Try this, in a separate column put the formula:
=IF(IsText(cell),1,0)
then just sum that column.
JBeaucaire
Dec 3, 2008, 05:10 PM
This is the formula you want:
=COUNTIF(CallSign,"*")
mdosh01
Dec 4, 2008, 06:21 AM
Just to throw in another option, if by "text" you mean cells that are not empty, you can use:
=counta(Callsign)
Assuming "Callsign" is the range in question.
ScottGem
Dec 5, 2008, 01:49 PM
Comments on this post
K4IE (https://www.askmehelpdesk.com/members/k4ie.html) disagrees: I may have done something wrong, but it returned a 0. I used another suggestion =countif(callsign, "*" ) and that one worked
First, may I call your attention to the guidelines for using the comments feature found here:
https://www.askmehelpdesk.com/feedback/using-comments-feature-24951.html
As you note, you may have done something wrong, so why did you give me a negative comment?
I had actually tested this before answering. I've attached a copy of a spreadsheet that shows that it works. In column A, I placed a text a blank and a number. In column B I placed the same formula I gave you in the 3 rows. Only the column containing a text value returned a 1.