Forum Discussion
SUMIFS multiple criteria and date
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. https://docs.google.com/spreadsheets/d/15en52LRP42uod-uDMaN-1QDOQtEavbbw/edit?usp=sharing&ouid=113345548149136228081&rtpof=true&sd=true
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'.
Thanks! Take a look at the attached version. If you change the property in B2 temporarily, you should see the numbers change.
4 Replies
Clicking on your links results in an "Unauthorized" error.
- raicar01Copper Contributor
Sorry about that. HansVogelaar
https://docs.google.com/spreadsheets/d/15en52LRP42uod-uDMaN-1QDOQtEavbbw/edit?usp=sharing&ouid=113345548149136228081&rtpof=true&sd=true
Thanks! Take a look at the attached version. If you change the property in B2 temporarily, you should see the numbers change.