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
---
"Connie Martin" wrote:
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