NEED A FORMULA FOR AN ARRAY

[HUSKER55]

I am putzing, and I ran into a snag. if I have colums A thru G and Rows 1 thru 10 and I want to add, what is the formula to do it.

I end up with numbers that are way off the scale.

I tried {(sum(a1:g1+a1:a10))}

thanks
:)

[Snag]

If I understand your question:

SUM(A1:G10)

I'm using MS Excel 2007

[headhawg]

Wow. I guess by the reply you really did run into a Snag. ;)

If I am reading your question correctly it's just =SUM(A1:G10)

[HUSKER55]

I am having one of those days that is supposed to happen to someone else.

It is worse than I thought cause I can't even expain it right.

I want to add cloumn a2 to b1, a3 to b1 and etc.
Then go a2 to b2, a3 to b2 and etc

I am trying to make a grid

thanks
:)

[chickenhead]

I dont really understand what you are doing. If you are trying to populate a grid (multiple cells) based on adding one cell iteratively through a column , I just do the caveman approach -- use a $ to fix the row or the column and then fill down and it will increment the other variable.

a2 to b1, a3 to b1 >> =a2+$b$1, then fill down (will give you the range of values you want)

a2 to b2, a3 to b2 >> =a2+$b$2, then fill down (will give you the range of values you want down that column)

Its basic but it works. There probably is some advanced array math in excel, but I dont know it.

[HUSKER55]

THAT IS what I did but I was thinking there should be an easier way.

perhaps not...

thanks!