View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Sum Function w/ #DIV/0!

=SUMIF(A1:A500,"<="&99^99)

--


Regards,


Peo Sjoblom

"Biff" wrote in message
...
Is there a way that I can add a column that includes #DIV/0!

Biff