SUMPRODUCT

[George]

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

 

[Luke M]

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))