View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M Moore M Moore is offline
external usenet poster
 
Posts: 10
Default Purpose of double negative

Could someone explain the purpose of a double negative in the following
formula:

-sumproduct(--Isnumber(match($a$2:$a$15000,Namedrange,0))

Thanks.