Using Excel sumifs to sum matrix elements
excel, sumifs
Solution
Maybe this formula could be extended to your needs: (data in A1:D3)
=SUMPRODUCT(--ISNUMBER(MATCH(B1:D1,{"d","e"},0)*MATCH(A2:A3,{"b"},0)),B2:D3)
Problem
Is it possible using Excel's sumifs to find the sum of elements of a matrix using condition on row and column? For example matrix: ``` c d e a 1 2 3 b 4 5 6 ``` I would like to sum elements of b row, d and e columns. The solution should work also for large dimension matrix. Sorry for ugly formatting.