count number of cells within a certain date

[BrutalLogiC]

Hi I have a list of contracts that includes their end date and their annual value,

e.g.
A1 = name of contract
B1 = 31/12/2018 (end date)
C1 = 500,000 (contract value)

I want a formula to count how many dates in column B fall within a particular month and another formula to sum the corresponding contract value of column C.

e.g.
E1 = January 2019
E2 = looks at E1 and counts how many dates in column B fall within January 2019
E3 = looks at E1 and sums the corresponding value in column C for those contracts ending in January 2019

Hope that's clear!! Thank you!

 

[BrutalLogiC]

I put this in E2 and it seems to work

=COUNTIF(Sheet1!$B:$B,"31/1/2018")-COUNTIF(Sheet1!$B:$B,"1/1/2018")

Not sure how I work out the values

 

[Aladin Akyurek]

In E2 enter:

=COUNTIFS(Sheet1!$B:$B,">="&"2019-01-01",Sheet1!B:B,"<="&EOMONTH("2019-01-01",0))

In E3 enter:

=SUMIFS(Sheet1!C:C,Sheet1!$B:$B,">="&"2019-01-01",Sheet1!B:B,"<="&EOMONTH("2019-01-01",0))