Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum data from 2 columns with Divide function
Hi,
Is there a quick way of getting a total sum for 2 columns of data whereby I need to divide data in each each row by the row beside it and just get a total at the end without the need for creating a row first with the divide formula? i.e current formula is A1/B1+A2/B2+... but I have thousands of rows and I'd rather not have to add an extra column to the spreadsheet ...I just need a total at the end. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum data from 2 columns with Divide function
Hi
Use this simple formula, just remember to press CTRL+SHIFT+ENTER not just ENTER when you have entered this array formula: =SUM(A1:A1000/B1:B1000) Regards, Per "snowball" skrev i meddelelsen ... Hi, Is there a quick way of getting a total sum for 2 columns of data whereby I need to divide data in each each row by the row beside it and just get a total at the end without the need for creating a row first with the divide formula? i.e current formula is A1/B1+A2/B2+... but I have thousands of rows and I'd rather not have to add an extra column to the spreadsheet ...I just need a total at the end. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! Need to divide all columns by same number to get sell price | Excel Worksheet Functions | |||
Autosum function not working | Excel Discussion (Misc queries) | |||
Where is the result after I do an autosum function? | Excel Discussion (Misc queries) | |||
Autosum function disappeared/knocked out | Excel Discussion (Misc queries) | |||
Divide date into separate columns | Excel Worksheet Functions |