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