SUMPRODUCT
 

Hello everybody,
I need somethig like this:
=SUMPRODUCT(--($A$3:$A$272=$X$1:$X$28);--($H$3:$H$272=$D3);--($B$3:$B$272=$T$1);$G$3:$G$272)

Normal formula is:
=SUMPRODUCT(--($A$3:$A$272=$X$1);--($H$3:$H$272=$D3);--($B$3:$B$272=$T$1);$G$3:$G$272)
but I need to compare arreas $A$3:$A$272 and $X$1:$X$28 at the same time

SUMPRODUCT
 

What exactly do you mean "compare... at same time"? Are you trying to check
if the values in A3:A272 appear anywhere in X1:X28?

=SUMPRODUCT((ISNUMBER(MATCH($A$3:$A$272,$X$1:$X$28 ,0)))*($H$3:$H$272=$D3)*($B$3:$B$272=$T$1)*($G$3:$ G$272))

--
Best Regards,

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


"George" wrote:

Hello everybody,
I need somethig like this:
=SUMPRODUCT(--($A$3:$A$272=$X$1:$X$28);--($H$3:$H$272=$D3);--($B$3:$B$272=$T$1);$G$3:$G$272)

Normal formula is:
=SUMPRODUCT(--($A$3:$A$272=$X$1);--($H$3:$H$272=$D3);--($B$3:$B$272=$T$1);$G$3:$G$272)
but I need to compare arreas $A$3:$A$272 and $X$1:$X$28 at the same time