not a logical 'and' in excel?
 

I am trying to do a countif statement for if two columns fulfill certain
criteria, as in:
If column A contains "text1" AND(&&) column B contains "text2" then count,
if only one of the criteria's is matched then dont count!

But i cant seem to get the && to work.
Thanks

=sumproduct(--(a1:1000="text1"),--(B1:B1000="text2"))

--

HTH

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


"marmie2005" wrote in message
...
I am trying to do a countif statement for if two columns fulfill certain
criteria, as in:
If column A contains "text1" AND(&&) column B contains "text2" then count,
if only one of the criteria's is matched then dont count!

But i cant seem to get the && to work.
Thanks