View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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