FORMULA

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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.
 
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
 
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
 
Hi
it could be that in your range to sum are some other cells which
contain an error value
 
Back
Top