In Microsoft Excel there are a handful of different functions for calculating the average for a set of numeric values. Moreover, there is an instant non-formula way. In this article, you will find a quick overview of all the methods illustrated with examples of use and best practices. Continue reading
Comments on: How to calculate average (mean) in Excel with or without formulas
by Svetlana Cheusheva, updated on
Comments page 2. Total comments: 52
Good morning,
We are trying to use the averageifs function over an array of number from C2:O1090 - is this possible as all examples point to a column average only?
Thank you.
Hello Jackie,
Thank you for your question! Until now I haven't realized that all the examples in this tutorial are for a column average, maybe because it's the most typical task.
In fact, you can supply absolutely any range to your Average formula, and even several ranges or individual cells separated by commas. So, the following formula will work just fine:
=AVERAGE(C2:O1090)
Is there any way to use the range in AVERAGEIFS? I have a block of data and need to take the average based on a column criteria and row criteria. Thanks.
Svetlana, I have a large data set of over 500 referential urls. The table contains both a count of page views and times spent on the page. I have the following formula that allows me to create a report that gauges interest by keyword in the urls. I need a formula which will filter the following conditions I used in my sumproduct formulat but which will give me an average instead of a sumproduct. Everything I have tried to make this happen has not worked. How can I use what you write above to accomplish this task. Your help would be appreciated. Many Thanks.
=SUMPRODUCT(('RAW DATA'!$A$2:$A$25000=B$336)*
('RAW DATA'!$E$2:$E$25000="micrositeABC")*
(MMULT(0+ISNUMBER(SEARCH(
{"rebate","savings"},
'RAW DATA'!$J$2:$J$25000)
),{1;1})>0),'RAW DATA - PAGE CATEGORIES'!$K$2:$K$25000)
– thanks for dropping by man! I like that you bring in a number of other areas and tie it into creation, I completely agree that this is the mode and task of the church today — to create a forum and median for pattpciiarion [in the Kingdom of God].
range is spelt as rage
**spelled
Thank you! Fixed.