Formula Help - Deals closed in 2020

I'm working in the Summary Sheet and attempting to get a total of deals closed in 2020 for only 4 of the 16 business units I have in my sheet. I'm using this formula:

=COUNTIFS([Business Unit]:[Business Unit], @cell = "Koala", Stage:Stage, @cell = "6 - Closed", IFERROR (YEAR @cell = 2020)

This is giving me an error message, but I still need to add the other 3 business units into this equation. Not sure where I'm going wrong. Thanks for any help you can provide.

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    In your year formula modify it like this:

    =IFERROR(YEAR([Your Column Name]@row), "")

    THis will make the column blank if there is an error and stop throwing that error in your countif.