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!

Find more posts tagged with

Accepted answers

All comments

Neil Watson

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

Sylvia Pérez

Hi!

It drops me invalid operation :/

Kelly Moore

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.