additional - formula error
 

CONFUSED
I may be using a formula that is trying to add to many cells at one time,
yet I've found nothing really to highlight the addion error. Long and short,
here is a formula I'm using and it appears the last cell is the one not
getting added.
=SUM(AQ47,AQ50,AQ53,AQ56,AQ59,AQ62,AQ65,AQ68,AQ71, AQ74,AQ77,AQ80,AQ84,AQ87,AQ90,AQ93,AQ96,AQ99,AQ102 ,AQ105,AQ108,AQ111,AQ114,AQ117,AQ120,AQ123,AQ126,A Q129,AQ132)

With that said, i can drop any number of the cells inside that have nothing
in them and I still get the same result with the adding error. Thanks for
the suggestion ahead of time
--
Rajj

additional - formula error
 

Assuming your title(information) row is row 1

Select A2 and WindowFreeze Panes.

As you scroll down the sheet row 1 will remain in view.

The freezing rule is...........all rows above and all columns left of the
selected cell will remain in view as you scroll.


Gord

On Wed, 2 Sep 2009 13:50:01 -0700, Rajj
wrote:

theres merit to that. I'd have to admit, I haven't used the tool enough to
even know something like that exists or even how it works.

additional - formula error
 

many thanks for that info...
--
Rajj


"Gord Dibben" wrote:

Assuming your title(information) row is row 1

Select A2 and WindowFreeze Panes.

As you scroll down the sheet row 1 will remain in view.

The freezing rule is...........all rows above and all columns left of the
selected cell will remain in view as you scroll.


Gord

On Wed, 2 Sep 2009 13:50:01 -0700, Rajj
wrote:

theres merit to that. I'd have to admit, I haven't used the tool enough to
even know something like that exists or even how it works.