multiple-columns

Using group by on multiple columns

Group By X means put all those with the same value for X in the one group. Group By X, Y means put all those with the same values for both X and Y in the one group. To illustrate using an example, let’s say we have the following table, to do with who is attending what subject at … Read more

Excel – SUMIFS for multiple columns

I would suggest to use SUMPRODUCT rather than SUMIFS. You can build something like that : The downside of SUMPRODUCT is that you can’t use a whole column (for example you cannot write SUMPRODUCT((B:B=”Sales”…)), this would generate an error). Hope this helps.

Using group by on multiple columns

Group By X means put all those with the same value for X in the one group. Group By X, Y means put all those with the same values for both X and Y in the one group. To illustrate using an example, let’s say we have the following table, to do with who is attending what subject at … Read more

Using group by on multiple columns

Group By X means put all those with the same value for X in the one group. Group By X, Y means put all those with the same values for both X and Y in the one group. To illustrate using an example, let’s say we have the following table, to do with who is attending what subject at … Read more