5. Sumifs()

One of the “must-know” formulas for a data analyst is =SUMIFS. =SUM is a familiar formula, but what if you need to sum data based on numerous criteria? It’s SUMIFS.

SYNTAX = SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …)

6. Averageifs()

AVERAGEIFS, like SUMIFS, lets you take an average based on one or more parameters.

SYNTAX = AVERAGEIFS (avg_rng, range1, criteria1, [range2], [criteria2], …)

Comments

Post a Comment

Popular posts from this blog

Image
  Data analysis is a valuable skill that can help you make better judgments. Microsoft Excel is one of the most used data analysis programs, with the built-in pivot tables being the most popular analytic tool. Microsoft Excel allows you to examine and interpret data in a variety of ways. The information could come from several different places. A variety of formats and conversions are available for the data. Conditional Formatting, Ranges, Tables, Text functions, Date functions, Time functions, financial functions, Subtotals, Quick Analysis, Formula Auditing, Inquire Tool, What-if Analysis, Solvers, Data Model, PowerPivot, PowerView, PowerMap, and other Excel commands, functions, and tools can all be used to analyse it.
Read more