Forum Discussion
raicar01
Mar 25, 2024Copper Contributor
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. 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'.
Thanks! Take a look at the attached version. If you change the property in B2 temporarily, you should see the numbers change.