View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default Simple formula, I'm sure

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