I think you're wanting SUMPRODUCT

=SUMPRODUCT(($B14='Namedata'!$M$3:$M$14707)*(W$5=' Namedata'!$AC$3:$AC$14707)*('Namedata'!$B$3:$B$147 07))

And your analysis is correct, its a way to have more than 1 cirteria and do
a sum based on those crtieria.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"XS" wrote:

I need to use the formula like

{=SUM(($B14='Namedata'!$M$3:$M$14707)*(W$5='Nameda ta'!$AC$3:$AC$14707)*('Namedata'!$B$3:$B$14707))}

What's the name of it?

It seems it reference some cell from other sheet to check whether the
criterias are fulfilled, if then SUM them?

Thanks.