Thread: What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)
Hi,

the Tilde sign (~) is telling the sumif formula to look for the * symbol and
not treat that symbol as a wildcard.

Mike

"Dorothy" wrote:

What does the ~ mean in formula =SUMIF(M13:M9087,"~**",E13:E9087)?
Reply With QuoteReply With Quote