Trying to create a Statement to capture all amounts greater than or equal $100.00 for a time period

Occasional Contributor

Trying to create a statement to capture all amounts greater than or equal to $100.00 for a Period End Date.

 

Like the image below.  I want to capture all amounts greater than $100.00 for 09/30/2021 and the count of how many.

 

HighFiveEm_0-1664477691858.png

 

2 Replies

@HighFiveEm 

=SUMPRODUCT(($A$2:$A$24=E5)*($C$2:$C$24>=100))

You can try SUMPRODUCT.

count for period end date.JPG

Thank you, but that didn't work for my example.