Answer the question
In order to leave comments, you need to log in
How to count the number of rows based on cell content criteria?
Good afternoon everyone. I just can't understand how to implement the following in Excel:
you need to find the number of rows, each of which simultaneously contains a cell with the text "Text1" and a cell with the text "Text 2" and a cell with the text "Text3".
Googled a lot, but everywhere they talk about counting cells, but I need to count rows.
Answer the question
In order to leave comments, you need to log in
=COUNTIFS()
The screenshot shows an example of usage.
Yellow cells - those that fall out of the selection
Green marked rows that match the condition
For example, the formula is indicated
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question