Thread: sum of cells that may contain #n/a
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default sum of cells that may contain #n/a
Hi,

If all the numbers are positive you can get away with

=SUMIF(A1:A20,"0")

if there may be negatives in the range use

=SUM(SUMIF(A1:A20,{"<0","0"}))

Mike

"Troy" wrote:

If I am summing cells that may or may not contain an error (#n/a) is there a
way to ignore these cells? Or replace (#n/a) with a zero?


Reply With QuoteReply With Quote