Counting values in one column based on a date range in another column

[Kelleyscott]

Please can you assist me with a formula for the query within the attached picture.

In cell E36, I am needing a formula that will 'count the number of times that Column E is greater than >$80,000.' However only those that are within the date range noted in Cells A1 (start of month) and A2 (today -1day).

Therefore the answer in Cell E36 should be 3 as there are 3 instances that the balance was greater >$80,000 (12/5, 13/5 & 20/5).

The formula will need the dates in Column A and the values in Column E - but I just can't get it right.
Your help is appreciated.

 

[Toadstool]

Hi Kelleyscott,

Does this work?

Book1
	A	B	C	D	E
1	01-May-20				7
2	21-May-20				EOD Baln
3	28-Apr-20
4	01-May-20				$ 87,554.00
5	03-May-20				$ 87,939.00
6	05-May-20				$ 88,401.00
7	07-May-20				$ 88,940.00
8	09-May-20				$ 89,556.00
9	11-May-20				$ 22,445.00
10	13-May-20				$ 23,215.00
11	15-May-20				$ 24,062.00
12	17-May-20				$ 79,033.00
13	19-May-20				$ 80,034.00
14	21-May-20				$ 81,112.00
15	23-May-20				$ 82,267.00
16	25-May-20				$ 83,499.00
17	27-May-20				$ 84,808.00
Sheet1

Cell Formulas
Range	Formula
E1	E1	=COUNTIFS($A$3:$A$999,">="&$A$1,$A$3:$A$999,"<="&$A$2,$E$3:$E$999,">"&80000)

 

[Kelleyscott]

Thank you Toadstool - yes it does. Sooo grateful for your time and knowledge. thanks

 

[Toadstool]

Glad I could help. COUNTIFS wants the same range for criteria so that's why it starts in the empty E3 so it can match with the first date.