Forum Discussion

Maddy1010's avatar
Maddy1010
Brass Contributor
Oct 11, 2022
Solved

Count if by month and year, by entity

Hello:  I am attempting to use count if the month and year are correct, and matching entity.  For example, on the attached, tab Headcount Analysis, cell Q8.  I would like to return the count of 2, re...
  • HansVogelaar's avatar
    Oct 11, 2022

    Maddy1010 

    In Q8:

    =COUNTIFS('Employee Data'!$I$8:$I$18,$C8,'Employee Data'!$Q$8:$Q$18,Q$7&"*"&$A$5)

Resources