Don't know if your "empty" cells are,
blank,
or null ( "" )
or
zeroes,
So, this may or may not work for you:
=IF(ISNA(LOOKUP(9.99999999999999E+307,D1:D11)),D12 ,LOOKUP(9.99999999999999E+
307,D1:D11)+D12)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
contain 0's, or nulls < "" , or
"SUB-ZERO" wrote in message
...
Hi
Is there any way to change the number of functions allowed in each cell?
I have a spreadsheet and I need it to handle more functions than 7.
10-15 functions wolud really work well for me.
Here is one example of what im working with, I need to have a few more
allowed functions for the formula to work correctly.
=IF(D11=0,D12,IF(D10=0,SUM(D11:D12),IF(D9=0,SUM(D1 0:D12),IF(D8=0,SUM(D9:D12)
,IF(D7=0,SUM(D8:D12),IF(D6=0,SUM(D7:D12),IF(D5=0,S UM(D6:D12),SUM(D5:D12)))))
)))
Any help would be greatly appreciated
Thanks ...
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from
http://www.shemes.com/ =-