How to use COUNTIF and IFERROR when referencing another sheet

Cassidy Tackett

=COUNTIFS({Committee Approval Status/Estado de Aprobacion}, "Approved / Aprobado", {Nominee's Work Location}, "Western", IFERROR(YEAR({Payroll Date}), 0) = 2025)

Paul Newcome

It should still be in the same syntax of range, criteria.

=COUNTIFS(……………………………….., {Payroll Date}, IFERROR(YEAR(@cell), 0) = 2025)

Paul Newcome

It should still be in the same syntax of range, criteria.

=COUNTIFS(……………………………….., {Payroll Date}, IFERROR(YEAR(@cell), 0) = 2025)

Cassidy Tackett

Thank you! That worked

Cassidy Tackett

=COUNTIFS({Committee Approval Status/Estado de Aprobacion}, "Approved / Aprobado", {Nominee's Work Location}, "Western", {Payroll Date}, IFERROR(YEAR(@cell ), 0) = 2024, ({Award Type}), "Starbucks - $25 gift card", "Western", {Authorized Date}, IFERROR(YEAR(@cell ), 0) = 2024)@cell

I need to add authorized date for a specific award because that award does not have a payroll date. I can't seem to put both payroll and authorized date together

Paul Newcome

Are you trying to do one or the other? If so, you will need to write two COUNTIFS (one for each of the date columns) and then add them together.