FORMULA

[Jerry]

I can calculate the sum of a column of numbers (even
though some cells within the column are not numbers but
text) and I receive the correct figure. HOWEVER, when I
apply this to a ROW, the SUM cells displays #VALUE! Why
is this? If I have text in a cell in a column and it can
sum it correctly, why can't it sum correctly a row with
text in some cells? Is there a work around? Thanks.

 

[Peo Sjoblom]

Probably because you have a cell with a value error in it in that row
for instance

=SUM(9:9)

will sum row # 9, if there are text it doesn't matter but if you have

#VALUE!

in one cell it will not work. For a workaround see

=SUMIF(9:9,"<>#VALUE!")

or find the cell with the error and kill the error

 

[CLR]

I use Excel2000, and the formula =SUM(rangeofcells) works for me in both
directions.

From the HELP.......

"What does the error #VALUE! mean?
The #VALUE! error value occurs when the wrong type of argument or operand is
used, or if the Formula AutoCorrect feature cannot correct the formula."

Perhaps you have a typeo in your horizontal formula?

hth
Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
it could be that in your range to sum are some other cells which
contain an error value