Forum Discussion

Copper Contributor

May 12, 2021

Sumproduct

Hello, I keep getting a #Value error with a simple Sumproduct formula. What am I doing wrong? Does the order of the arrays matter? Thank you.

Diamond Contributor

May 13, 2021

If with SUMPRODUCT()

=SUMPRODUCT(
  Source!$H$13:$P$21,
  MMULT(--(Source!$C$13:$C$21=$D12),
        --(Source!$H$9:$P$9=G$10))
)