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 04:37 PM.
How about...
=COUNTIF(A:A,"X")
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Perfect. Thanks.Originally Posted by jeffreybrown
Where is the "reputation icon" so I can give you credit ?
Never mind - found it.
*** deleted ***
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
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
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
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.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
Okay, thanks Jeff I will do that.
There are currently 2 users browsing this thread. (1 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks