|To check for all three conditions, try this:|
=COUNTIFS(A1:A5,"=Review",B1:B5,"<>Cancel for non Pay",B1:B5,"<>Cancel for Conversion",B1:B5,"<>Company Decline")
If you want to use cell references instead of the hard coded strings, you need to use the concatenation operator:
e.g. if Review was in G1, you would use this:
=COUNTIFS(A1:A5,"=" & G1, etc.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.