VBA to Count Cells with Specific Text - Count Cells with Criteria

Hello,
What if, I have multiple worksheets?
What is the syntax to enter more than one sheet name?

Simple and easy code, thank you

Thank you for this! Question, if i wanted to count more than value? Can it be done in the same macro?

Ok. Very good information..now I want to show the result in a textbox in userform ..how to do it..

Thanxx

In a similar manner for numbers and final list in descending order and repeat values

Thanks for providing hints on VBA for excel.
I would like to know if you could provide a vba proposition for:
- counting specific words in a cell containing a long text (and if possible regardless of case upper or lower).
- counting the number of cells where there is the occurrence of 2 or 3 words at the same time.

How about if you want it to show both Pune and mumbai but its numbers seperately not the total

I am getting better in this after watching your videos. this particular example of counting text in range I did with countif function which was very simple.

You are amazing!! Thank you for going in depth to explain and teach!!! I love this video!

is it possible that I can download this file and modify it for my own use? I don't understand the range mycell, is it referring to cell F2? Thanks.

I have one problem , I'm looking for vba :- for A column under from particular cell(A3) to the end of row( Ex;- A3 to A36{Automatically select >Shift+downArroW}, count the cells for that( i'm now using manually Counta function) , The counta function display the value in another cell(G1).. for all I give Worksheets name basis , its need count for all worksheets in same CELL(G1) Please help me.

Thanks , my code is now running

Many Thanks.. Very Helpfull

How to connect this all to a textbox in userform

I have a input data form that I use to input data into a work sheet, I
would like to see the number of unique text for that person when I
recall their data to the form. I want to count how many "yes" answers in
a column for a particular person and pass it to my upnput form once
the record for that person is called. is selected.I dont know the coding
but....something like if txtowner.value =xx then Txtyes.value =
cell.range F:F where xx and yes is true...something to that effect.

I have a input data form that I use to input data into a work sheet, I would like to see the number of unique text for that person when I recall their data to the form. I want to count how many "yes" answers in a column for a particular person and pass it to my upnput form once the record for that person is called. is selected.

good sir 👍👍👍👍plz make a video with emp name qty sales nd calculate auto total amount

Sir please guide how write in VBA (when a change is done in one of the table cell, the new value to be automatically stored in another table that will keep all the values(old and new)

How can I use sumifs via to sum data between tow date