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!

 

[Fluff]

How about

=COUNTIFS(C$3:C$10,C13,D$3:D$10,"N")

 

[B5rocksass]

It works! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[B5rocksass]

I am being asked to limit the fields by making sure the responses are only counted if a date field is 2 business days prior to today. Is there a way to work that into the formula? Can you help again? Thank you Thank you Thank you!!!

 

[Fluff]

Can you please post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[B5rocksass]

HERE YOU GO!

1-13-2021.xls
	A	B	C	D	E
1
2	Line A	Line B	Name	Yes/No	Line D
3	50	11/20/20	Abby	Y	50
4	10	11/13/20	Lenox	N	10
5	40	11/13/20	Abby	N	40
6	10	11/13/20	Lenox	Y	10
7	60	01/06/21	Abby	Y	60
8	10	01/13/21	Lenox	N	10
9	20	10/30/20	Lenox	N	20
10	10	02/05/21	Abby	N	10
11
12			Name	Quantity (N)
13			Abby	2
14			Lenox	3
Sheet1

Cell Formulas
Range	Formula
D13:D14	D13	=COUNTIFS(C$3:C$10,C13,D$3:D$10,"N")

 

[JamesCanale]

Add ...,B$3:B$10,workday(today(),-2)

 

[Fluff]

Thanks for that, should the count be limited to 2 days, or anything greater then 2 days ago?

 

[B5rocksass]

greater than 2 BUSINESS days. So if i pull a report today (1/14), it would be anything 1/12 and older.