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.

 

  • Perhaps

     

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

    • RaulChile's avatar
      RaulChile
      Copper Contributor

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

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        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?

Resources