use of AND worksheet function

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
=SUMPRODUCT((('raw stats'!$C$1:$C$500 = B3)*( 'raw stats'!$A$1:$A$500 =
"timeDH")*( 'raw stats'!$B$1:$B$500 =0))
 
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))
 
Back
Top