Excel "If" function giving problem when checking if all values are true

Question

I used the "If" and "Cont.se" function, but I wanted the "If" function to check if all sequence values of (C69:C73) are ="500", however when checking the penultimate value it considers that all values are "500" and the last value is "400" and soon after it runs the count of only the numbers "500" in the sequence (B69:B73) referring to the function "Cont.se", I wanted the function "Se" to consider if all values are "500" from the sequence of (C69:C73) and then run the formula, because the function "Se" Wouldn’t you consider all the values "500"? the latter being "400" ?? because in this case it should return "False" because all values are not "500", ?

=SE(C69:C73=500;CONT.SE(B69:B73;B72);0)

Answer 1

then I do not know why this error. But I believe that if you have to solve something very urgent I have a solution a little more laborious.

The solution is as follows: Count how many values of C69:C73 = 500 with the formula - > =CONT.SE(C69:C73;500)

Count the number in the range C69:C73 with the formula - >=CONT.NÚM(C69:C73)

Count the number of empty cells in the range C69:C73 with the formula -> =COUNT.EMPTY(C69:C73)

Then add the amount of compared cells by summing F73 + F74 as per image.

Then compare NUMBER QUANTITY = 500 (F72) with QUANTITY OF COMPARED CELLS(F75) FORMULA -> =SE(F72=F75;"EQUAL";"DIFFERENT")

Finally, if the Cell I72 = "EQUAL" if it is equal count the number of times 500 appears in the range B69:B73 with the formula - > =SE(I72="EQUAL";CONT.SE(B69:B73;500);"NOT COUNTED")