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
HansVogelaar's avatar
HansVogelaar
MVP
Jan 04, 2024

Perhaps

 

=SUMAR.SI.CONJUNTO(Sheet1!SumRange1; Sheet1!CriteriaRange1; Criteria1; ...)-SUMAR.SI.CONJUNTO(Sheet2!SumRange2; Sheet2!CriteriaRange2; Criteria2; ...)

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

    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?

Share