I have two columns of Data: a1 thru a20 and b1 thru b20. I want to average a1 with b1, a2 with b2, etc. I want the average to display in column c.
Is there a way I can create a formula that does that where I don't have to do it for each line individually?
Thanks.
Kenny
Try this one
=AVERAGE(A1:B20)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You can easily "fill down" or drag down the formula, e.g. put this formula in C1
=AVERAGE(A1:B1)
Now put the cursor on the bottom right corner of cell C1 until you see a black "+" - that's the "fill-handle". Double-click on that and the formula will populate all the way down while there is continuous data in an adjacent column. The cell references will adjust accordingly
Another way is to make your data into a table (Select all the data and from the Insert tab choose Table) - formulas entered at the top are automatically filled down - and if you add rows those will be included too
Audere est facere
HI Al...I actually can do that. What I need to do is =AVERAGE(A1:B1). But is there a way to write the formula that keeps me from having to do it individually for each line?
See my answer........
Awesome! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks