use of AND worksheet function

[Frank]

Hwo can I use the AND to check for a value in a set of ranges on another
worksheet?


AND('raw stats'!$C$1:$C$500 = B3, 'raw stats'!$A$1:$A$500 = "timeDH",
'raw stats'!$B$1:$B$500 =0)

does not seem to work

Thanks,

Frank

 

[Jim]

=SUMPRODUCT((('raw stats'!$C$1:$C$500 = B3)*( 'raw stats'!$A$1:$A$500 =
"timeDH")*( 'raw stats'!$B$1:$B$500 =0))

 

[J.E. McGimpsey]

AND won't work because it gives a single answer for the whole set of
arguments (i.e., if any comparison in the ranges is False, AND
returns FALSE).

Use SUMPRODUCT instead:

=SUMPRODUCT((--('raw stats'!$C$1:$C$500 = B3),--('raw
stats'!$A$1:$A$500 = "timeDH"),--('raw stats'!$B$1:$B$500 = 0))