ApriltheVA
New Member
- Joined
- Apr 24, 2020
- Messages
- 10
- Office Version
- 2016
- Platform
- Windows
- Web
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
I do hope someone can help. Thanks.
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.