Thank you Mr. Kaper

But there are some things to adjust.
The formula works almost perfectly
but if there are other columns with data between the column and the other data columns, it no longer works.

Another minor problem is that when I insert the formula it displays the range incorrectly

column A is reserved for the condition, so it should not be displayed as part of the range.

The counting range is $B$3:C3 not $A$3:C3

please include the option to ask for column with condition that if there are other columns with data between the
columns numbered and the column of data make it does not alter the result.


Thank you