sumif criteria dates and year

[sureshsonti]

Hello,
I have an excel sheet with datasheet tab and profit_loss tab.
In the datasheet i enter dates and rent collected
I am using SUMIFS function to extract data from datasheet tab to profit_loss tab using the dates in the datasheet tab.
If I change the year in profit_loss tab the amounts in the profit_loss should reflect 2019 data.
SUMIFS function should include the year criteria with dates.

=SUMIFS(revenue,revenuedate,">="&0+("1/"&D$4),revenuedate,"<="&EOMONTH(0+("1/"&D$4),0),propertyname,$B6)

revenue is a table
revenuedate is a named range column
propertyname is a named range column

Thanks for all your help. I have attached sample file

 

[vletm]

sureshsonti
for cell D6
=SUMIFS(revenue,revenuedate,">="&1&D$4&$B$2,revenuedate,"<="&EOMONTH(1&D$4&$B$2,0),propertyname,$B6)

 

[sureshsonti]

Vietm,
Thanks for solving my issue. Your formula worked. I have a question in the formula. What does 1 mean before the ampersand


=SUMIFS(revenue,revenuedate,">="&1&D$4&$B$2,revenuedate,"<="&EOMONTH(1&D$4&$B$2,0),propertyname,$B6)

 

[vletm]

sureshsonti
1 is as the 1st day of Month.

 

[sureshsonti]

Really appreciate your help on this issue. Thanks again

 

[p45cal]

You can also do this quickly without formulae with a pivot table and slicer.
See attached.

 

[sureshsonti]

p45cal
Thanks for your solution. Really appreciate taking your time to find a solution. Thanks again