**- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -**

Calculations in Excel Using Whole Row or Column

Posted By __ On June 14, 2010 @ 10:03 AM In ____MS Excel__ | __Comments Disabled__

Do you have calculations – may a sum or average or whatever – from the set of data?

And when the amount of data increases what do you do with your formulas?

If you’re changing the cell range each time then I know that you’re frustrated.

Or maybe you wrote the formula by using the address of the first and last cells in the row or column?

And while once you know the address of the last cell it certainly makes for some long formula strings – which can be difficult to edit and handle later on.

So the question must be asked … is there a simpler way? Maybe something that doesn’t require continual formula editing or obnoxiously long formulas?

A simple way you ask – no problem.

When writing a formula that should use the data in an entire column/row,

Sounds confusing I know but wait – a quick example will clarify things immensely.

Let’s say that I need the average of all data in column A. In the location I want the average placed use this:

=AVERAGE(

Need a calculation from an entire row? =AVERAGE(

Well, you get the idea…

I’m not sure we could write a cleaner formula for any calculation and the happy news is that this one replaces others that had the potential to be messy and annoying!

~April

Article printed from Worldstart's Tech Tips And Computer Help: **http://www.worldstart.com**

URL to article: **http://www.worldstart.com/calculations-in-excel-using-whole-row-or-column/**

Click here to print.