Jump to content

Count Strings in Worksheet


Recommended Posts

Hello all,

I was wondering if there was a way to count strings in a worksheet? The values are not in under a database row, they are just punched in stings to cells. I've tried nesting them in "INT" or "Value" functions and using them with "COUNT" or "SUM" functions but to be honest a bit frustrated that I can't even figure out this. What would you suggest?

EDIT: my strings are basically dates in this format; mm/dd/yy

Edited by sle7en7
Link to comment

If what you want is just to know that a cell has data you can use an extra column with an IF statement.

IF(A2='',0,1)

What this says in English is that if there is nothing in cell A2 then use a value of zero for this cell, otherwise use a value of one for this cell.

You should then be able to use a Count function to get the total you are looking for.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...