CountIF formula with 3 criteria help please

ealexis

Hello,

I am trying to use the CountIF formula with 3 criteria.

1st criteria: date needs to between between 12/31/2023 and 5/5/2024

2nd criteria: intake status needs to be not blank

3rd criteria: must match zip code

I am getting "incorrect argument set". Can anyone help?

This is my formula below:

=COUNTIFS({BROWARD UP REQUEST INFORMATION created}, >=DATE(2023, 12, 31), {BROWARD UP REQUEST INFORMATION created}, <=DATE(2024, 5, 5), {Intake Status}, <>"", {zipcode}, "33309")

AravindGP

Hi @ealexis

You shouldn't specify a number in quotes. Try this instead

=COUNTIFS({BROWARD UP REQUEST INFORMATION created}, >=DATE(2023, 12, 31), {BROWARD UP REQUEST INFORMATION created}, <=DATE(2024, 5, 5), {Intake Status}, <>"", {zipcode}, 33309)

ealexis

@AravindGP unfortunately that did not work.

KPH

Hi, Your syntax looks fine. It is probably an issue with the cross-sheet references, which we cannot see.

Please check that all of those references are in the same sheet, and are the same size/shape (for example if one is only 10 rows, they must all be only 10 rows).

ealexis

Hello @KPH

All of the references are indeed in the same sheet, and have the same amount of rows.

KPH

I'm not sure what to suggest next. Can you try re-building the cross sheet references? Just in case something weird has happened to them.