Sumif multiple columns

Question

Hi masters,

I would like to create a total column base on the following "IF" logic:

IF Type='E' THEN sum(A1:A6) ELSE sum(B1:B6) ENDIF

AccountOrgTypeA1A2A3A4A5A6B1B2B3B4B5B6003325011E13-18224531116-291621220910018B23224-172633452207-18220910011B3121116-29211329162113001318013E291621132916132916211329001318018B172683345223121116-45003325011E45316211329-291616-29

The expected result should have a total column as following:

AccountOrgTypeTotal003325011E101220910018B125220910011B113001318013E124001318018B87003325011E127

Thanks for your help

Felipe_Ribeir0 · Accepted Answer

Hi @Felipe_Amancio

One way of doing this:

Matthew · Accepted Answer

this should work

my solution has one less row than your desired output because the Account, Org, and Type are identical. you need something unique to differentiate these rows if you want them separate

danilang · Accepted Answer

Hi @Felipe_Amancio

If the number of columns is constant over time, you can always just use a simple formula tool

if [Type] = "E" then
   [A1]+[A2]+[A3]+[A4]+[A5]+[A6]
else
   [B1]+[B2]+[B3]+[B4]+[B5]+[B6]
endif

Dan