Autosum data from 2 columns with Divide function

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
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top