how do I fix #DIV/0! error?

  • Thread starter Thread starter babygirl
  • Start date Start date
B

babygirl

My formula is =SUM(C7:N7)
I want to add the values of c7,d7,e7,f7,g7,h7,i7,j7,k7,l7,m7,n7.
There is no divor in my eqaution so I don't understand why I am getting this
error message.

Please help. This is driving me crazy.
 
Believe you are getting the error because one or more of the source cells in
C7:N7 is returning this #DIV/0! error value

Instead of: =SUM(C7:N7)
try this: =SUMIF(C7:N7,"<>#DIV/0!")
 
Back
Top