Use Countif Function
Formula: copy to clipboard
=COUNTIF('GENERAL (2)'!J791:J795,"A")


The range J791:J795 has been merged and marked with the text A.

So countif will get the result as 1.