View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Summing all cells containing the letter K

The "double unary minus" converts a logical (TRUE or FALSE) value to a
number (1 or 0).
--
David Biddulph

"Jan T." wrote in message
...
Thank you very much for helping.
But can you tell me, what does the two minus before (--ISNUMBER... do?

Jan

"Teethless mama" skrev i melding
...
=SUMPRODUCT(--ISNUMBER(SEARCH("K",A1:F1)))