SUMIFS multiple criteria and date

[raicar01]

Hi there, 

I am trying to use Sumifs for property mgmt, filling in one sheet to populate individual properties and sum the portfolio as a whole, coupled with the year. I have the whole part down, but I am having issues using multiple criteria for the individual.

file here. Test

I.e. Rent from one year(1/1/24), for property "425", paid as "direct rent" would flow to both 'Annual Summaries' and '425'. Similarly with expenses based on the list under 'Data Validation'.

[#2]

@raicar01 

Clicking on your links results in an "Unauthorized" error.

[#3]

Sorry about that. @HansVogelaar 

Test 

[#4 · Accepted solution]

@raicar01 

Thanks! Take a look at the attached version. If you change the property in B2 temporarily, you should see the numbers change.

[#5]

@HansVogelaar thanks so much. I basically had it mirrored to you but must have had a typo somewhere. Perfect!