Help debugging a Sumproduct for criteria in 2 rows and 1 column

[alyssa75]

Hi Guys -

Can someone help me come up with a formula that will be the equivalent of the below but without the need for arrays (Ctrl-shift-enter)?

=SUMPRODUCT((Expenses!$R$10:$R$26=$O19)*(Expenses!$T$5:$BG$5=$B$3)*(Expenses!$T$7:$BG$7=B$6)*Expenses!$T$8:$BG$26)


Thanks!
Alyssa

 

[Marcelo Branco]

Your formula is not correct (red)

=SUMPRODUCT((Expenses!$R$10:$R$26=$O19)*(Expenses!$T$5:$BG$5=$B$3)*(Expenses!$T$7:$BG$7=B$6)*Expenses!$T$8:$BG$26)

I think (guessing) it should be
=SUMPRODUCT((Expenses!$R$8:$R$26=$O19)*(Expenses!$T$5:$BG$5=$B$3)*(Expenses!$T$7:$BG$7=B$6)*Expenses!$T$8:$BG$26)
confirmed with just Enter

M.