Solved Power Query SumIfs Into Two Columns

April 9, 2020 at 11:43:03
Specs: Windows 10
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              4

I want to sum the above into 1 single row:

       
          A           B             C           D
1       Color        Yes           No         Total
2       Green        12            4           16

I 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


See More: Power Query SumIfs Into Two Columns

Reply ↓  Report •

#1
April 9, 2020 at 17:32:49
✔ Best Answer
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)

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Start a discussion
Related Solutions
See More ↓


Ask Question