Forum Discussion

RaulChile's avatar
RaulChile
Copper Contributor
Jan 04, 2024

Formulas

I need to sumar.si.conjunto with two sum ranges in different sheets, one is income the other is outcome. so they rest themselves, anyone can Help? Thanks.  
office 365
RaulChile's avatar
RaulChile
Copper Contributor

Thanks a lot, but it gets Value at the end.

HansVogelaar's avatar
HansVogelaar
MVP
Jan 04, 2024

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

  • RaulChile's avatar
    RaulChile
    Copper Contributor
    Jan 04, 2024

    Listen, I have one sheet with entrys of spares, so I entry quantity I buy, then I have another sheet where I  put spare I use in a car. To Get how many remains I have to Sumar.si.conjunto both quantities in diferent sheets. One in entry, another in Deliver. see?

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jan 05, 2024

      Does this do what you want?

       

      =SUMIFS([Cantidad],[Repuesto],[@Repuesto])-SUMIFS(Tabla2[Cantidad],Tabla2[Repuesto],[@Repuesto])

       

      =SUMAR.SI.CONJUNTO([Cantidad];[Repuesto];[@Repuesto])-SUMAR.SI.CONJUNTO(Tabla2[Cantidad];Tabla2[Repuesto];[@Repuesto])

Resources