What would be the formula for: if column A range contains apples and pears then count column c that contains cancelled or pending Thanks in advance