Thread: SUMPRODUCT/COUNTIF
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon Car Jon Car is offline
external usenet poster
  
Posts: 1
Default =SUMPRODUCT(COUNTIF(O153:S550,{"Unknown"}),{1})
=SUMPRODUCT(COUNTIF(O153:S550,{"Unknown"}),{1}) I want to know if I could put a cell value instead of entering a word where unknown is? Any help is appreciated. thank you.
Reply With QuoteReply With Quote