Average help

**bmillerins** · 08-03-2009, 04:32 PM

I need some help with figuring an AVERAGE from 4361 cells... looking to get a blended rate on pricing.

I am not even sure if excel can avg that many cells.

Any advice or tips would be greatly appreciated... as you have probably conclude... I am a very below "average" Excel user.

Thanks

**JBeaucaire** · 08-03-2009, 04:37 PM

Excel is perfectly capable of handling basic averaging, even of entire columns of data.

=AVERAGE(E:E)

=AVERAGE(E1:E4361)

You can press F1 in Excel and enter a keyword or two when you're looking for a new function, Excel will offer many suggestions and tutorial on how to use them.

**ChemistB** · 08-03-2009, 04:41 PM

Excel can certainly AVERAGE much more than 4361 cells. Are all of these cells in a single column? Are they within a congruent range (e.g. within 1 area) or non-congruent columns?
As an example, lets say the pricing is in Columns B, C and D, from rows 2 to 2000.

Please Login or Register  to view this content.

or if it's in Columns B, E, and G from row 2 to 2000

Please Login or Register  to view this content.

Does that help?

**bmillerins** · 08-03-2009, 05:37 PM

Thanks!!!!

**JBeaucaire** · 08-03-2009, 07:49 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)