COUNTIFS - Too Many Arguments

[ApriltheVA]

I thought I understood the formula but I keep getting this error.

Goal:
1. Count the number of "Admission" in Column B, only if Column J says "Vent"
2. Count the number of "Discharge" in column B, only if column J says "Vent"

current formula: =COUNTIFS(B5:B28,"ADMISSION", J5:J28,"VENT")

I attached a link to a sample template

Dropbox - File Deleted - Simplify your life

www.dropbox.com

I do hope someone can help. Thanks.

 

[ApriltheVA]

Some of the cells in column J says "VENT/WEANED"

 

[Fluff]

How about
=COUNTIFS(B6:B43,"DISCHARGE",J6:J43, "*VENT*")