SOLVED

Count if by month and year, by entity

Contributor

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, representing 2 new hires in July for Entity Pluto. 

 

Please can you help me out with formula combining ifs scenarios?

 

2 Replies
best response confirmed by Maddy1010 (Contributor)
Solution

@Maddy1010 

In Q8:

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

It works! Why am I not surprised. Thanks Hans!!