I made up a spreadsheet to calcualte how many calories you burn during exercise. The spreadsheet has 18 lines per week, with each line representing an exercise. Right now I'm only doing 5 different cardio exersises so the other 13 lines show the word #DIV/0 because I haven't entered in any data into those lines. The problem is I want a sum of total calories burned at the end of the week but it won't add it up because of the #DIV/0 in the other 13 lines. What can I do?

something like:
=if(denominator=0,0,equation)

If the denominator is 0, it'll enter a 0. Otherwise it'll use the equation.

I used the if function and here is the equation I put:

IF(denominator=0,0,equation)+J7:J24

Where I want the sum to be this #NAME? is there instead

You sorta missed a few steps, maybe I wasn't explicit enough. You're supposed to substitute your equation for "equation" and substitute the denominator of the equation (that's apparently giving a division by zero error) as "denominator".

This if statement is also supposed to be the formula you use in the #DIV/0 cells, not in the cell that sums them.

If you're not understanding, you can email me the spreadsheet (scott@theskyiscrape.com) and I can show you an example.

thank you I finally figured it out. One more question can I also do an average if ? Because I have the same problem with the average.