i have a command button , need coding in a command button that calculates how many time a word "Yes" comes in the range ("E4:E100") comes.Ths should happens in command click coding.
i have a command button , need coding in a command button that calculates how many time a word "Yes" comes in the range ("E4:E100") comes.Ths should happens in command click coding.
Please Login or Register to view this content.
Hi, mubashar,
you could use WorksheetFunction CountIf for that:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks