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 |
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 |