COUNTIF with AND function

Mahshad Farmanbar

Hi there,

I'm trying to count the instances that a contract has been executed and occurred in the year 2020. The formula I have unfortunately returns as "incorrect argument set". Any help would be greatly appreciated.

=COUNTIF([Status of Contract]:[Status of Contract], "Executed", AND([Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020))

Kelly Moore

Hey @Mahshad Farmanbar

When dealing with multiple criteria, you need to use COUNTIFS (plural) instead of COUNTIF (singular). As a point of note, COUNTIFS (plural) can always be used, regardless if one criteria or many. Note that the criteria within the COUNTIFS are already 'AND' criteria

=COUNTIFS([Status of Contract]:[Status of Contract], "Executed", [Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020)

cheers,

Kelly

Kelly Moore

Hey @Mahshad Farmanbar

When dealing with multiple criteria, you need to use COUNTIFS (plural) instead of COUNTIF (singular). As a point of note, COUNTIFS (plural) can always be used, regardless if one criteria or many. Note that the criteria within the COUNTIFS are already 'AND' criteria

=COUNTIFS([Status of Contract]:[Status of Contract], "Executed", [Date Received]:[Date Received], IFERROR(YEAR(@cell), 0) = 2020)

cheers,

Kelly