SOLVED

SUMIFS multiple criteria and date

Copper Contributor

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'.

 

4 Replies

@raicar01 

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

Sorry about that. @Hans Vogelaar 

 

Test 

best response confirmed by raicar01 (Copper Contributor)
Solution

@raicar01 

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

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

1 best response

Accepted Solutions
best response confirmed by raicar01 (Copper Contributor)
Solution

@raicar01 

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

View solution in original post