What do you get with this formula:

=count(E3,G3,I3,K3,M3,O3,D3)

If all the cells have real numbers in them, you should see 7. If you see any
other result, then either you have empty cells or you have non-numeric data in
at least one of those cells.

And just reentering the value isn't enough.
Try formatting the cells as General (or Number)
then reenter the values.

Then check your formula.

ps. Peo changed your formula to something that you may not want.

Add those ()'s in the divisor.

=SUM(E3,G3,I3,K3,M3,O3)/(D3*12)



TanaMary wrote:

Nope....that's not it....tried all the cells (and even reentered the number
values in the cells I'm calculating)

"Peo Sjoblom" wrote:

First question is why are you using both SUM and operands like +?

If you use

=SUM(E3,G3,I3,K3,M3,O3)/D3*12

The reason you get value error is that at least one of the cells is text.

Try


=ISTEXT(E3)

and so on to test all the cells

if it returns TRUE it is text

--


Regards,


Peo Sjoblom

"TanaMary" wrote in message
...
I did a spread sheet to track payments and the percentages of those
payments
bi-monthly over a 12 month period. There are 6 percentage columns total
for
each entry. It's a progressive formula as we need to review the
percentages
bi-monthly. Thus, this is the formula I used in the first set of cells:

=sum(E3+G3+I3+K3+M3+O3)/(D3*12)

After making sure the values worked properly, I copied the formula down
the
columns (we have 102 entries so far). When nothing is entered in column
E,
the sheet shows #DIV/O!, which is fine. As soon as values are added, it
shows 0% in all the percentage columns.

I noticed today that the last three columns for just one of the cell lines
shows "#VALUE!"; the first three columns for the same line are fine. I
checked the formula both below it and above it and they are identical
except
for the cell number. I tried deleting the formulas in those cells and
then
duplicating them again by a copy down the column, but still get the same
error and I can't figure out where the error is???

HELP!!!

KM





--

Dave Peterson