Please help with IF index formula

[B5rocksass]

Hello, I have a table with multiple pieces of data (changed for data security). I need to look in the table and look down one column to find specific text, then look to the next column to see if that text matches a criteria, and return the total number of values that match that criteria. So, in the example I've shown below, the final table should show Abby with a quantity of 2, and Lenox of 3. The actual document has hundreds of rows. Please help!

 

[B5rocksass]

James, I tried to add that to the end of the existing formula and it came back with a value of zero.

 

[JamesCanale]

...,B$3:B$10,"<="&workday(today(),-2)

 

[JamesCanale]

=COUNTIFS(C$3:C$10,C13,D$3:D$10,"N",B$3:B$10,"<="&workday(today(),-2))

 

[Fluff]

Ok, how about

=COUNTIFS(C$3:C$10,C13,D$3:D$10,"N",B$3:B$10,">"&WORKDAY(TODAY(),-2))