Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formulas

Copper Contributor

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.

 

5 Replies

Perhaps

 

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

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

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?

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?

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])