Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a column of data where most cells have first character "," however I want to include in a countifs formula an argumant which includes counting of cells that begin with a letter.

share|improve this question

closed as not a real question by DragonLord, Dennis, ChrisF, HackToHell, Ƭᴇcʜιᴇ007 Feb 10 '13 at 14:30

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
I'm sorry, but I can't understand your question. –  Dennis Feb 9 '13 at 2:24
    
please post a data sample and mock up the expected result(s) –  teylyn Feb 9 '13 at 5:23
    
Columnn M , H The formula needs to be , T , S If left (M:M,1) is a letter , R or , S If left (M:M,1) is not a "," , R Gg- Do you know the syntax? , S , N Hs- , S , W –  Topless Feb 9 '13 at 8:44
    
That didnt format well. Perhaps if I put it this way. –  Topless Feb 9 '13 at 8:45
    
I am trying to count cells in which the contents string does not start with a comma. The other way of putting it is that I want count cells in which contents string does start with a letter (any letter either upper or lower case) –  Topless Feb 9 '13 at 8:48

1 Answer 1

The following countif will count any cell starting with a-z or A-Z, with zero or more following chars.

=COUNTIF(A1:A7,"[a-zA-Z]*")
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.