FORMULA

[Jerry]

This is a weird question. I have established a formula
to count the numbers in a column utilizing =SUM(A1:A5).
Some of the cells within the column, I have text. The
formula ignores the text and gives me the sum of the
numbers in the other cells. However, when I utilize the
same scenario with text in some cells within a ROW and I
use the formula =SUM(A1:G1) I receive a #VALUE! return.
Why is this? If it can perform a sum going down in a
column (with some cells having text in them) then why
can't it do the same in a row? This makes no sense to
me. Could someone please explain a workaround for this
to me?

 

[jeff]

Hi, Jerry,

Sorry, but I tried it and it works both ways for me.
(wouldn't you know!) What version are you running?

I'd check the data in your rows to make sure there's
not something bad with the data.

Others may know of this...?
jeff

 

[Dave Peterson]

Do you have #value!'s in that range (a1:g1)?
Maybe hidden by format|conditional formatting???