Try the COUNTIF function...
Hope this helps!
Welcome to Oz.
Did you not find an answer among the serveral "Possible Answers" at the top of your post? There are several that apply to your situation as this question has been asked and answered before.
One answer from one of the "POssible Answers": =COUNTIF(A1:A100, "text")
Take some time to review search results first before posting a question.
AAE, thank you for your respose. I actually did NOT find the answer as you mentioned, as the countif didn't work exactly as I needed it to. And since I was being a good boy and not ASSUMING that countif was what I needed (although trying it extensively) I was following Dave Hawley's guidelines when seeking assistance.
Because the "text" portion of the formula varies, it doesn't help me to have "text" as the input criteria. And when I try this countif(A1:A100, B2) I get a column of values that descend rather than give definitive values. This is because when I paste the formula through the column the first value increases as it goes down the cell.
Let me give you an example of what I mean....
When I use countif(A1:A100, B2), I get results as follows:
What I need are results like:
Does that make sense? The descending values are due to the dynamic nature of countif(A1:A100, B2), The A1 portion increases automatically- if there is a way to make this value static- that is probably one way to solve this.
Auto Merged Post;
Let me add a bit more to this. If I use countif(A1:A100, B2), how can I make the A1 value static, and the B2 value dynamic in this function? This would work as a possible solution.
Last edited by serasbach; December 15th, 2007 at 04:53. Reason: Auto Merged Doublepost
Thank you!And since I was being a good boy and not ASSUMING that countif was what I needed (although trying it extensively) I was following Dave Hawley's guidelines when seeking assistance.
BTW, a one Column PivotTable would give you a tally count
There are currently 1 users browsing this thread. (0 members and 1 guests)