Growth Worksheet Function on Excel 2003

[Norm]

I am trying to predict what next months (weeks) sales will
be. After looking at Excel help I have determined that
Growth will work. However, I end up with "#Num!" if the
known x's are numbers for the month and "#Value!" if the
months are text. I can copy the example out of help and
it works. The only difference that I can see is my known
y's are numbers in a row rather than a column. I am
stubborn but I can't see why that would make a
difference. I have used a formula to point to my known
y's so that they are contiguous but I have changed the
formule to constants with no change. The lenght of my y's
equal the lenght of my x's. What have I done wrong?

 

[hgrove]

Norm wrote...

. . . The only difference that I can see is my known y's are number in a row
rather than a column. I am stubborn but I can't see why that woul make a
difference. . . .

If your know ys are in a row (so perhaps B2:U2) and your known xs in
column (like A3:A22), GROWTH(B2:U2,A3:A22) *will* return an error. I
this is really the case with your ranges, then you must either abando
your stubbornness and wrap one or the other inside TRANSPOSE, or find
different way to get the same result. The choice is yours