V
V
Vladimir Banduristov2016-12-01 10:10:30
excel
Vladimir Banduristov, 2016-12-01 10:10:30

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

1 answer(s)
S
shushpanio, 2016-12-01
@webzlodimir

=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 indicated33f74cc55bd74b218975706548f2dd20.jpg

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question