I agree. Thank you Ron for that first option. I didn't know you could use Sumproduct that way. You have saved me from making unnecessary extra columns in the future.