=SUMIFS(sum_range, criteria_range1, criteria1,, …)Īdds the cells specified by a given set of conditions or criteria =AVERAGEIFS(average_range, criteria_range1, criteria1,, …)įinds average (arithmetic mean) for the cells specified by a given set of conditions or criteria =AVERAGEIF(range, criteria, )įinds average (arithmetic mean) for the cells specified by a given condition or criteriaĪdds the cells specified by a given condition or criteriaĬounts the number of cells within a range that meet the given condition If a cell is not blank, it returns FALSE.Ĭhecks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSEĬhecks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSEĬhecks whether a reference is to a cell containing a formula, and returns TRUE or FALSEĬhecks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSEĬhecks whether a value is #N/A, and returns TRUE or FALSEĬhecks whether a value is a number, and returns TRUE or FALSEĬhecks whether a value is a reference, and returns TRUE or FALSEĬhecks whether a value is text, and returns TRUE or FALSEĬhecks whether a value is not text (blank cells are not text), and returns TRUE or FALSE I have documented every Excel formula with its syntax and a good number of examples.ġ02 Most Useful Excel Formulas with Examples A. Provide Your Valid Email Id below to download the PDF & Excel Files with 102 Excel Functions. N.: I did not include here the specialized formulas for Engineering, Statistical, Web, etc. You cannot use this PDF for any kind of commercial use.ī. You can download the PDF and print it to use it anywhere, but for personal use. In this Excel Formulas Tutorial, I am sharing here the most useful 102+ Excel formulas cheat sheet and downloadable free PDF. You can use this trick to master anything complex, not only Excel formulas. This helps me a lot while I am trying to solve an Excel problem with formulas. Then wherever I see the name of an Excel formula, I can quickly remember its syntax and uses. This revision makes a permanent image of the formulas in my brain. Let me share the trick that I used and still use to master the formulas: I used to revise 5-10 Excel formulas every day before start working anything with Excel. To be frank, it is not an easy task for all as the functions are a lot in numbers. If you want to be a power user of MS Excel, you must master the most useful Excel formulas of Excel.
Get FREE Advanced Excel Exercises with Solutions!
0 kommentar(er)
