Thread: Sum Function w/ #DIV/0!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
  
Posts: 57
Default Sum Function w/ #DIV/0!
For column A try

=SUMIF(A:A,"<#DIV/0!")
Reply With QuoteReply With Quote