how do I fix #DIV/0! error?

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.
 
M

Max

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!")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A staying on schedule formula: 2
Long formula 17
If condition to find Target 1
IF Statement 2
How do I display 0 if it is the end result for a formula 4
Combination to Two formulas with the Help of AND / OR / IF Functions 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
Adding numbers from other sheets? 2

Top