sle7en7 Posted March 31, 2015 Share Posted March 31, 2015 (edited) 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 March 31, 2015 by sle7en7 Quote Link to comment
Pat Stanford Posted March 31, 2015 Share Posted March 31, 2015 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. Quote Link to comment
sle7en7 Posted March 31, 2015 Author Share Posted March 31, 2015 (edited) Ok Pat thanks a lot, good to know the least. EDIT: I guess we can add "STR2NUM" kind of function to a wishlist but I'm sure it's in needle&mortar somewhere. Edited March 31, 2015 by sle7en7 Quote Link to comment
Recommended Posts
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.