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.

 

[Norie]

That formula looks fine and works in the workbook you linked to.

The only problem in that workbook is a circular reference in B50.

 

[Fluff]

Hi & welcome to MrExcel.
Where are you trying to put the formula?
If I put it in B50 I get 5 & if I extend the range to cover the data I get 10

 

[ApriltheVA]

Hi & welcome to MrExcel.
Where are you trying to put the formula?
If I put it in B50 I get 5 & if I extend the range to cover the data I get 10

The formula would go at the bottom of the spreadsheet. The formula is for the entire spreadsheet.

 

[Fluff]

First you need to delete the contents of B50 as it's causing a circular reference, as pointed out by Norie.
Then put the formula in whatever cell you want, there is nothing wrong with it.

 

[ApriltheVA]

Thank you guys so much for helping.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[ApriltheVA]

First you need to delete the contents of B50 as it's causing a circular reference, as pointed out by Norie.
Then put the formula in whatever cell you want, there is nothing wrong with it.

The cells with VENT/WEANED aren't counted. How do I include this into the formula?

 

[Fluff]

What do you mean?

 

[ApriltheVA]

What do you mean?

I didn't put the entire spreadsheet only half, so you didn't see it.
The formula counted the column B if column J says vent; however some cells in column J says

Here is the same spreadsheet. I added those columns and put the formula at the bottom.

Sample spreadsheet.xlsx

Shared with Dropbox

www.dropbox.com