Hi is their is better way to find how many items of a certain kind is in a column
then using For Next loop. for example
apple
apple
apple
orange
orange
result = 4 apples
2 oranges
these is just an example is not the program that
Iam trying to aplied to.
jotol,
Try Application.Worksheetfunction.Countif(range, "item") like so:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Tanks TigerAvatar for the code, But supose we want to search
a range for an Item and then count how many items are in that range
would this still work?
I don't see why it wouldn't. Can you give some more specifics?
Yes, I Have two columns Column1 = stages and column 2 = State( Open or Close)
so I want to be able to count how many open were their and How many Close
for each stage. In total their is 7 stages but each stage could have close to thousands
states.
Last edited by jotol; 05-02-2013 at 11:38 PM.
jotol,
Attached is a sample workbook based on the criteria you described.
Column A contains the seven different stages
Column B contains their states (Open/Close)
Then the quantity of the state per stage is in the table in columns D through F, with this formula in cell E3 and copied over and down:
Please Login or Register to view this content.
If it needs to be VBA instead, just use the Application.Worksheetfunction.Countifs to do the same thing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks