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.