Autosum data from 2 columns with Divide function

  • Thread starter Thread starter snowball
  • Start date Start date
S

snowball

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
 
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
 
Back
Top