Forum Discussion
Solved
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, bu...
Thanks! Take a look at the attached version. If you change the property in B2 temporarily, you should see the numbers change.
Clicking on your links results in an "Unauthorized" error.
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.
HansVogelaar thanks so much. I basically had it mirrored to you but must have had a typo somewhere. Perfect!