Try
=SUMPRODUCT(--(Listing!I2:I420={"EXE","000"}))
--
Regards,
Peo Sjoblom
"Trixie" wrote in message
...
Peo & Bob, Thanks for your help previously.
The only thing not covered was if there are multiple arguments (say a
combination of text & or numbers). I tried this:
=COUNTIF(Listing!I2:I420,"EXE","000")
and keep getting:
"You've entered too many arguments for this function."
|