I am trying to do a sumif in power query, but also split the column with amounts into two, my example below A B C 1 Color Identifier Amount 2 Green Yes 7 3 Green Yes 5 4 Green No 4I want to sum the above into 1 single row:
A B C D 1 Color Yes No Total 2 Green 12 4 16I can sum the columns (various ways, no issues there), but I always end up with two rows, I can not find a way to consolidate everything into one row
I do not have Power Query as I'm still on 2007
but wouldn't some SUMIFS() get you the answers?For Column B: =SUMIFS(C2:C4,A2:A4,"Green",B2:B4,"Yes")
For Column C: =SUMIFS(C2:C4,A2:A4,"Green",B2:B4,"No")
For Column D: =SUMIF(A2:A4,"Green",C2:C4)