I am trying to count the entries in column A based on conditions for the
adjacent cells in columns A and B of the same record both being true. I
attempted the entry below but it continually caused the error message to
throw. Suggestions Anyone?

=COUNTIF(AND(('WORKSHEET1'!$A:$A,"Argument_A"),('W ORKSHEET1'!$B:$B,"Argument_B"))))