| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Need help with simple formula please | Excel Discussion (Misc queries) | |||
| help with simple formula | Excel Worksheet Functions | |||
| Need a simple formula please | Excel Worksheet Functions | |||
Threaded Mode
