How do I combine COUNTIF and AND functions in Excel

[J Roney]

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"),('WORKSHEET1'!$B:$B,"Argument_B"))))

 

[Bob Phillips]

=SUMPRODUCT(--('WORKSHEET1'!$A:$A="Argument_A"),-('WORKSHEET1'!$B:$B="Argume
nt_B"))

--

HTH

RP
(remove nothere from the email address if mailing direct)

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"),('WORKSHEET1'!$B:$B,"Argument
_B"))))

 

[Peo Sjoblom]

=SUMPRODUCT(--(Range1="x"),--(Range2="y"))

note that you cannot use the whole column as range (A:A)

--

Regards,

Peo Sjoblom

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"),('WORKSHEET1'!$B:$B,"Argument
_B"))))