Forum Discussion

raicar01's avatar
raicar01
Copper Contributor
Mar 25, 2024
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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Mar 25, 2024

    raicar01 

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

raicar01's avatar
raicar01
Copper Contributor
Mar 25, 2024

Sorry about that. HansVogelaar 

 

https://docs.google.com/spreadsheets/d/15en52LRP42uod-uDMaN-1QDOQtEavbbw/edit?usp=sharing&ouid=113345548149136228081&rtpof=true&sd=true 

HansVogelaar's avatar
HansVogelaar
MVP
Mar 25, 2024

raicar01 

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

  • raicar01's avatar
    raicar01
    Copper Contributor
    Mar 25, 2024

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