Countif function that works separately but not when I put them together.

Rayme

COUNTIFS({Ops Design Pathfinder Range 1}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Ops Design Support System - Resolved Range 1}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

I can get them to work when I break them apart but it gives me an "incorrect argument set" when I put them together

Paul Newcome

You cannot reference two separate sheets within the same function.

Are you trying to have both counts added together? If so, you would use two separate COUNTIFS and add them together.

=COUNTIFS(.......) + COUNTIFS(.......)

Paul Newcome

You cannot reference two separate sheets within the same function.

Are you trying to have both counts added together? If so, you would use two separate COUNTIFS and add them together.

=COUNTIFS(.......) + COUNTIFS(.......)

Rayme

Thank you, I'll make the update

Paul Newcome

Happy to help. 👍️