Forum Discussion
RaulChile
Jan 04, 2024Copper Contributor
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.
RaulChile
Jan 04, 2024Copper Contributor
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
Jan 05, 2024MVP
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])