Thread: show 0 instead of DIV/0
View Single Post
 
Old 05-15-2015, 12:15 PM
Jackie Jackie is offline Windows 8 Office 2013
Novice
  
Join Date: Nov 2014
Posts: 18
Jackie is on a distinguished road
Default show 0 instead of DIV/0
Hi

When I am trying to add the following column cells I am getting DIV/0 as some of these cells themselves have DIV/0 as there is no data results in some of them.........Please can anyone tell me how to show 0 instead of DIV/0

=SUM(M11+S11+Y11+AE11+AK11+AQ11+AW11+BC11)

Thank you
Reply With Quote