Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically filling additional cells with formula Sapper Excel Discussion (Misc queries) 3 May 5th 09 04:54 PM
Nesting an additional formula in an IF statement Karsea New Users to Excel 12 February 10th 09 10:16 PM
additional conditions to SUMPRODUCT formula Fiona Yorke-Saville Excel Discussion (Misc queries) 3 January 23rd 09 03:04 PM
Copy Formula to additional columns Lise Excel Discussion (Misc queries) 3 March 20th 08 08:48 AM
retain formula in additional workbooks Lynch New Users to Excel 1 January 30th 06 08:11 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"