Thread: Advanced Apology
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wilson Wilson is offline
external usenet poster
  
Posts: 18
Default Advanced Apology
=SUMPRODUCT(--('Raw Data'!I4:I4902="NA"),--('Raw Data'!D4:D4902="0"),--('Raw
Data'!D4:D4902<""))

and

=SUMPRODUCT(('Raw Data'!I4:I4902="NA")*('Raw Data'!D4:D4902="0"))

returned ZEROS.

I am baffled
Reply With QuoteReply With Quote