NOT filter

You can use NOT filter count plays that don't match some criteria. It is useful in many situations. Some of them are listed below:

• The formula that counts all kill attacks in transition:
  • = VSCOUNT(VSAND("*A#","*R;B-0;NOT"))

• The formula that counts all the player #4 attacks after the reception when he didn't pass the ball:
  • =VSCOUNT(VSAND("*4A","*4R;B-0;NOT","*R;B-0"))

  
  

• The formula that counts all the player #5 attacks side-out attacks when the reception was negative:
  • =VSPER(VSAND("*5A#","*R;B-0",VSOR("*R+;B-0;NOT","*R#;B-0;NOT")))