Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically filling additional cells with formula | Excel Discussion (Misc queries) | |||
Nesting an additional formula in an IF statement | New Users to Excel | |||
additional conditions to SUMPRODUCT formula | Excel Discussion (Misc queries) | |||
Copy Formula to additional columns | Excel Discussion (Misc queries) | |||
retain formula in additional workbooks | New Users to Excel |