Sorry Guys, I must be thick.

Doesn't seem to matter how I type in the command it gives me an error. Here are the cell details;
Cells AB14 to AB5033 have dropdown options 'Active, Cancelled, Completed, Suspended'.
Column AP is using a countif to show if 'Completed' has been chosen in column AB and is working well. The count in any cell in AP is of course either 0 or 1. That's OK.
Column AQ is where I want to show if either of the other 3 options in AB have been chosen. Again it will of course only total to 0 or 1 in each cell in AQ. That's OK. I just can't get it to happen.
Having a total that only shows 0 or 1 may sound odd but it suits my purpose. All other formulas and functions that I have on the sheet are working well but this one is giving me a real headache. Surely it is simpler than the hassle it is giving me!

Cheers,

JLB.