I have a spreadsheet where I have some data. Of these data, I need to count the values that are repeated from a column SE
the cell value of the same row, but from another column, is equal to a given value.
I made the following formula:
SE(A:A=valor;CONT.SE(D:D; valor_a_ser_contado);"Nenhum valor encontrado")
But it always returns me "Nenhum valor encontrado"
even though the values match.
Example: in the A column I have 5 values, 5 of which are equal to "10" and the other 5 are random values. In the lines where the A value is 10, I want to count how many cells in the D column have the value "VERDADEIRO"
.
Could you help me with this formula?