View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Father
 
Posts: n/a
Default SUMIF exluding text

Hello I am trying to sum data in a column based on the absence of a character
in a related column.
That is to say I need to be able to exclude rows that contain an "m" (there
may be multiple characters in the criteria cell)
Anyone have any ideas?