Simple formula, I'm sure

[Connie Martin]

It's gotta be simple, for my complex mind can't simplify it!! B39 divided by
the sum of J42:J5000. I can't put a sum in J5001 and have it as simple as
B39 divided by J5001 because this is an ongoing spreadsheet and may at times
only reach 1000 rows. J5000 is chosen for the formula to be sure that ample
number of rows are given for the data. Thank you. Connie

 

[Max]

Maybe you could use something like this:
=IF(ISERROR(B39/SUM(J$42:J$5000)),"",B39/SUM(J$42:J$5000))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Shane Devenshire]

Hi,

It's not clear what your problem is? The formula
=B39/SUM(J42:J5000)
Can be put in any cell of the spreadsheet, for example, at the top, say J40.

The other alternative is to put it in J5001 and then use an AutoFilter, with
Non Blank as the criteria. Highlight the range J42:J5001 and choose Data,
Filter, Auto Filter. Then open the auto filter drop down and choose
NonBlanks. This will hide all the blank rows between J42 and J5001.