I just need the quickest and most simple way to finding how many rows in my worksheet contain a value of 'X' in column A.
The first row of the worksheet contains column names. Column A is called "SpecialFlag". Most of the rows are "normal" and contain NULL (or an empty string) in Column A.
I need to know simply how many rows are marked with SpecialFlag = "X".
Last edited by jjamjatra; 12-02-2011 at 05:37 PM.
How about...
=COUNTIF(A:A,"X")
HTH
Regards, Jeff
Perfect. Thanks.Originally Posted by jeffreybrown
Where is the "reputation icon" so I can give you credit ?
Never mind - found it.
*** deleted ***
I found the reputation icon and clicked on it for you. That is all. Hopefully, I can find how to mark this closed/answered.
Take a look at the FAQ
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save
How would you do the countif with multiple values, say that you have 50 thousand rows, the cells have a mix of numbers ranged from 1-6 in those rows. How would I do a count on the rows with the values of 1 showing and then 2 showing and then 3 showing, etc. Can the formula =COUNTIF(A:A,"X")
be used for multiples on the criteria?
Please follow the forum rules and create your own thread.
Okay, thanks Jeff I will do that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks