Forum Discussion
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.
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])