If you have Microsoft Office installed, but have never touched Excel before because you either didnt know how to use it or didnt know what it could do fo. Learn how to use the Sumif function in Excel demonstrations, examples tutorial videos. Sometimes calles sumif statement. A spreadsheet application by Microsoft. Use this tag along with vba if your question involves programming Excel in VBA, and with worksheetfunction if it involves. Introduction This site provides illustrative experience in the use of Excel for data summary, presentation, and for other basic statistical analysis. The Excel AVERAGEIF Function. Home Excel Built In Functions Excel Statistical Functions Excel Averageif Function. Function Description. The Excel AVERAGEIF function finds the values in a supplied array that satisfy a specified criteria, and returns the average i. The function is new in Excel 2. Excel. The syntax of the Averageif function is AVERAGEIF range, criteria, averagerange Where the function arguments are range An array of values or range of cells containing values to be tested against the supplied criteria. The condition to be tested against each of the values in the supplied range. An optional array of numeric values or cells containing numbers for which the average is to be calculated, if the corresponding value in range satisfies the supplied criteria. If the averagerange argument is omitted, the average is calculated for values in the initial supplied range. How To Use The Average Function In Microsoft Excel 2007' title='How To Use The Average Function In Microsoft Excel 2007' />The supplied criteria can be either a numeric value including integers, decimals, dates, times, and logical values e. TRUEora text string e. Text, Thursday this MUST be supplied in quotesoran expression e. MUST be supplied in quotes. Note also that the Excel Averageif function is not case sensitive. So, for example, the text strings TEXT and text will be evaluated as equal. How To Use The Average Function In Microsoft Excel 2007' title='How To Use The Average Function In Microsoft Excel 2007' />Excel Averageif Function Examples. Cells A1. 6 A2. 0 of the following spreadsheet shows five examples of the Excel Averageif function. For each call to the Excel Averageif function the range argument to be tested against the criteria is the cell range A1 A1. B1 B1. 4.  Formulas ABC1. Monday. 50. 0 2. Tuesday. How To Use The Average Function In Microsoft Excel 2007' title='How To Use The Average Function In Microsoft Excel 2007' />Thursday. Friday. 10. 0 5. Thursday. TRUE2. 00 1. 3TRUE2. FALSE5. 0 1. 5   1. AVERAGEIF A1 A1. Thursday, B1 B1. AVERAGEIF A1 A1. B1 B1. Baixar Programa Que Reproduz Videos Rmvb Converter. AVERAGEIF A1 A1. B1 B1. AVERAGEIF A1 A1. TRUE, B1 B1. AVERAGEIF A1 A1. TRUE, B1 B1. Results AB1. Monday. Tuesday. Thursday. Friday. 10. 05. Thursday. TRUE2. 00. 13. TRUE2. FALSE5. 01. 5  1. Note that, in cells A1. A1. 8 and A2. 0 of the above Formulas spreadsheet, the text value Thursday and the expressions 2 and lt TRUE are encased in quotes. The Excel Averageifs Function Calculates a Conditional Average, Based on One or More Criteria Function Description, Examples Common Errors. This is essential for all text or expressions. For further examples of the Excel Averageif function, see the Microsoft Office website. Averageif Function Errors. If you get an error from the Excel Averageif function, this is likely to be one of the following Common ErrorsDIV0 Occurs if either None of the values in the supplied range array satisfy the supplied criteria The values to be averaged are all non numeric. VALUE Occurs if the criteria argument is a text string that is greater than 2.