5",C2:C5) returns the average of all values with a value greater than 25 : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial " /> 5",C2:C5) returns the average of all values with a value greater than 25 : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial "/>

=AVERAGEIF(B2:B5,">5",C2:C5) returns the average of all values with a value greater than 25 : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

1. Introduction

2. Editing

3. Format Style

4. Table

5. Chart

6. Formula

7. Workbook Worksheet

8. Wordart Clip Art Shape Picture

9. PivotTable PivotChart

10. Data Analysis

11. Macro ActiveX Add in

12. Security

13. Collaboration

14. Database functions

15. Date Time functions

16. Engineering functions

17. Information functions

18. Logical functions

19. Lookup Reference functions

20. Math Trigonometry functions

21. Statistical functions

22. Text functions

Java

Java Tutorial

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Java Articles

Java Products

Java by API

C# / C Sharp

C# / CSharp Tutorial

ASP.Net

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML / CSS

HTML CSS Reference

C / ANSI-C

C Tutorial

C++

C++ Tutorial

PHP

Python

SQL Server / T-SQL

Oracle PL / SQL

Oracle PL/SQL Tutorial

PostgreSQL

SQL / MySQL

MySQL Tutorial

VB.Net

VB.Net Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Microsoft Office Excel 2007 Tutorial » Statistical functions » AVERAGEIF

21. 3. 2. =AVERAGEIF(B2:B5,">5",C2:C5) returns the average of all values with a value greater than 25

`Input the formula: =AVERAGEIF(B2:B5,">5",C2:C5). Press Enter to get the result.`

21. 3. AVERAGEIF
21. 3. 1. AVERAGEIF(range,criteria,average_range) returns the average of all the cells in a range that meet a given criteria
21. 3. 2. =AVERAGEIF(B2:B5,">5",C2:C5) returns the average of all values with a value greater than 25 5",C2:C5) returns the average of all values with a value greater than 25" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/averageifb2b5gt25c2c5_Returns_Average_Of_All___Input_Formula_.PNG" width=200, height=40>
21. 3. 3. =AVERAGEIF(A2:A6,"=Item*",B2:B6) returns the average of all values

w_w_w._ja_va2s.com_ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.