The portions of the formula that exclude "IN" and "OFF" in the month formula are: *(OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"IN")*(OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"OFF")*
In the year formula they read: *(OFFSET($A8,0,1,1,372)<>"IN")*(OFFSET($A8,0,1,1,372)<>"OFF")*
One option would be to continue that trend and add a segment such as *(OFFSET($A8,0,1,1,372)<>"OV")* for each code you wish to exclude.
Possibly a better method would be to append the original month array formula so that it reads as follows:
Note that criteria 1 for the COUNTIFS function is a range (NX12:NX14) that includes "IN", "OFF", and "OV". If a new code is added which should excluded from the count then the range can be extended to include that code. For instance if "CO" should be included the range could be modified to read NX12:NX15.
A similar array formula is used for the yearly count.
Let us know if you have any questions.
Bookmarks