countif value in ranges

[kmlloyd]

I have attached a sample. I need something that will return the # of employees that have Months of Service within a given range (col A) and a Termination Reason that matches the reasons in Row 1.

TIA!

[NBVC]

Convert column A into the upper bound number of months, e.g. 3, 6, 12, 36, 60, 120, 240 and make the 20+years something big, like 1000...

then in B2:
=SUMPRODUCT(--('YTD Terms'!$C$2:$C$40<=$A2),--('YTD Terms'!$B$2:$B$40=B$1))-SUM(B$1:B1)

copied across the matrix

adjust ranges to suit.

[kmlloyd]

thank you so much!