CountIfs returns an unexpected number

  • In order to be on the safe side, attached is your Test file with both solutions ...


    Given your very important number of records, It seems to me your calculation time will be drastically improved with a macro ;)


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • De nada :)


    y para 2021 :


    ¡Feliz Año Nuevo!

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)