Sumproduct = 0

[Chiragshah15]

Hi,


the sumproduct formula I have below returns no values, never had this one before...can anyone help?

=SUMPRODUCT([1Data.xlsm]Submissions!$A$4:$A$14=$B$4)*([1Data.xlsm]Submissions!$G$4:$G$14=$F6)*([1Data.xlsm]Submissions!$H$4:$H$14=$G6)*([1Data.xlsm]Submissions!$I$4:$I$14=$H6)*([1Data.xlsm]Submissions!$J$2:$U$2=N$3)*([1Data.xlsm]Submissions!$J$4:$U$14)

Thanks

C

 

[barry houdini]

Looks like you have some parentheses missing - what do you get with this?

=SUMPRODUCT(([1Data.xlsm]Submissions!$A$4:$A$14=$B$4)*([1Data.xlsm]Submissions!$G$4:$G$14=$F6)*([1Data.xlsm]Submissions!$H$4:$H$14=$G6)*([1Data.xlsm]Submissions!$I$4:$I$14=$H6)*([1Data.xlsm]Submissions!$J$2:$U$2=N$3)*([1Data.xlsm]Submissions!$J$4:$U$14))

 

[Chiragshah15]

it works...woohooo!!!

Many thanks...so simple but so effective!!