How do I combine COUNTIF and AND functions in Excel
 

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"))))

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

--

HTH

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


"J Roney" <J wrote in message
...
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"))))

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

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

--

Regards,

Peo Sjoblom


"J Roney" <J wrote in message
...
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"))))