I have created a spread sheet that tracks the average of data for the year. Can I enter two formulas to a cell.

I am using 1 formula to calculate each month=AVERAGE(), this works correctly.

But since some months have no data entered, I receive the #DIV/0!

I understand as I enter each month data the message goes away.

My total for the year will not calculate as long as the #DIV/0! is listed.

​I have created a spread sheet that tracks the average of data for the year. Can I enter two formulas to a cell.I am using 1 formula to calculate each month=AVERAGE(), this works correctly.But since some months have no data entered, I receive the #DIV/0!I understand as I enter each month data the message goes away.My total for the year will not calculate as long as the #DIV/0! is listed.   Read More

​