Countif by individual date

[jsmooth47]

I have a column of dates and a column of actions (buy and sell). I need to be able to count how many buys or sells there were on each individual day. I have part of of the formula as Countif(B2:B1000,"Buy"). I need to know how to add onto this to be able to count the buys on say 1/1/2017.

Any help out there geniuses?

 

[AnalystMind]

=COUNTIFS(range where you have your dates,"1/1/2017",range where you have buy/sell,"buy")

 

[AhoyNC]

Depends on the ver. of Excel you have.
Either COUNTIFS or SUMPRODUCT

Excel Workbook
	A	B	C	D	E
1	Date	Buy/Sell		For Date:	1/1/2017
2	1/1/2017	Buy			3
3	1/4/2017	Buy
4	1/1/2017	Sell			3
5	1/5/2017	Buy
6	1/1/2017	Buy
7	1/1/2017	Buy
8	2/3/2017	Sell
Sheet