In a cell of the worksheet 1, I want that it is seen the worksheet 2, column C, and to tell how many to times the word "EME" it appears in the column To, but only if value 1 appears in adjacent column N in the same row.
In a cell of the worksheet 1, I want that it is seen the worksheet 2, column C, and to tell how many to times the word "EME" it appears in the column To, but only if value 1 appears in adjacent column N in the same row.
In that cell enter the below formula
=SUMPRODUCT(--(Sheet1!$A$2:$A$10=B$1),--(MONTH(Sheet1!$B$2:$B$10)=MONTH($A2)))
You can use the COUNTIF function as follows:
Assuming your list starts at A1 and goes down to A100
or you can just specify the whole of column A with=COUNTIF($A$1:$A$100,"apple")
=COUNTIF($A:$A,"apple")
There are some similar threads found same that theirs the problem that I have is the connection… Only if the solution to its problem is there…. I hope that it finds its solution….
How to count number of text occurences in Excel column
How to count number of characters in Excel
How to count number of words automatically?
How To Count The Number Of Characters?
Count number of time user has logons Windows 2003
Formulas to count the occurrences of text, characters, or words in Excel
Bookmarks