Sumproduct - Non Adjacent Cells

[cshetty]

Dear Experts

Please help me with this formula to sum non adjacent cells based on criteria.

=SUMPRODUCT(((Schedule!$M$5:$M$2316),(Schedule!$O$5:$O$2316))*(Schedule!$D$5:$D$2316>=$B4)*(Schedule!$D$5:$D$2316<=EOMONTH($B4,0))*(Schedule!$G$5:$G$2316=P$3))

Getting #Value error.

Thanks in advance.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Peter_SSs]

Dear Fluff

This is it. Thanks mate.

Good news. Since I was on about removing parentheses before, there are a few that could be removed from that formula too if you want

=SUMPRODUCT(((Schedule!$M$5:$M$2316)+(Schedule!$O$5:$O$2316))*(Schedule!$D$5:$D$2316>=$B4)*(Schedule!$D$5:$D$2316<=EOMONTH($B4,0))*(Schedule!$G$5:$G$2316=P$3))