Date Count Based on Date in Another Cell

[richmcgill]

I am needing three formulas to help counting dates

The number of dates / rows shrinks and grows daily and there is a lot of other information above and below the dates that are being counted so that information needs to stay in tact. The date in cell A2 is a fixed date and not a Today formula 1. Count All Dates that IS equal to the date in A2 and has any amount in the "Amount" column

2. Count All Dates that are NOT equal to the date in A2 and has any amount in the "Amount" column

3. Count All Dates on that are NOT equal to the date in A2 and has an amount of $0.00 in the "Amount" column

<colgroup><col width="760" style="width: 570pt; mso-width-source: userset; mso-width-alt: 27794;"> <col width="360" style="width: 270pt;"> <tbody> </tbody>

Date	Amount
5/20/2019	$3.90
3/1/2019	$81.65
4/15/2019	$985.00
5/24/2019	$168.84
5/29/2019	$0.00
5/30/2019	$181.90
6/7/2019	$0.32
5/30/2019	$40.16
6/3/2019	$560.96

<colgroup><col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <tbody> </tbody>

Could look like this
1. 9
2. 13
3. 12
34

 

[Joe4]

You should be able to use COUNTIFS function, much like your other question that was answered.
Give it a go, and see how you do and post back with your attempts if you run into any trouble.