Sumif 2 columns met a condition
Hi Im trying to sum the total of utility made by transfer. So I need a formula that sums the column " Importe" if the column "Tipo Ingreso/Gasto"= " Transferencia" and if the column " Ingreso o Gastos" = " Ingresos" and then substract the same conditions but by the " Ingreso o Gastos" = " Gastos"
I made this formula but it doesn't work:
=SUMIFS([Tipo Ingreso/ Gasto]2:[Tipo Ingreso/ Gasto]501; ="Transferencia" ; [Ingreso o Gasto]2:[Ingreso o Gasto]501 = "Ingresos"; Importe2:Importe501)- SUMIFS([Tipo Ingreso/ Gasto]2:[Tipo Ingreso/ Gasto]501; ="Transferencia"; [Ingreso o Gasto]2:[Ingreso o Gasto]501 = "Gastos"; Importe2:Importe501)
Can somebody help me please 😥
Thank you!
Answers
-
SUMIFS( range, criterion_range1 criterion1, [ criterion_range2criterion2... ]), where range = The group of cells to sum
Maybe try:
=SUMIFS( Importe:Importe, [Tipo Ingreso/ Gasto]:[Tipo Ingreso/ Gasto], ="Transferencia", [Ingreso o Gasto]:[Ingreso o Gasto] = "Ingresos") - SUMIFS(Importe:Importe, [Tipo Ingreso/ Gasto]:[Tipo Ingreso/ Gasto], ="Transferencia", [Ingreso o Gasto]:[Ingreso o Gasto] = "Gastos")
You may need to swap ; and , depending on regional settings
-
Hi!
It drops me invalid operation :/
-
Hello
I built on Neil's formula by adding inadvertently missed commas/semi colons.
=SUMIFS(Importe:Importe; [Tipo Ingreso/ Gasto]:[Tipo Ingreso/ Gasto]; "Transferencia"; [Ingreso o Gasto]:[Ingreso o Gasto]; "Ingresos") - SUMIFS(Importe:Importe; [Tipo Ingreso/ Gasto]:[Tipo Ingreso/ Gasto]; "Transferencia"; [Ingreso o Gasto]:[Ingreso o Gasto]; "Gastos")
cheers
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives