| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a formula to an entire column
I can not figure out how to apply a continual formula to a column of figures.
Ex. There is a specific number is cell A1. I would like to enter a formula of "=sum(A4/A1)" into cell B4 Then.........................................."=su m(A5/A1)" into cell B5 How do I get an entire portion of column A to all be divided by cell A1 and put the answers in the corresponding B cells ? Thank you in advance for your time ! Much appreciated ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| a fomula for an entire column | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
