What is the SUMIFS Function in Excel? We all know the SUMIF function allows us to sum the data given based on associated criteria within the same data. However, the SUMIFs Function in Excel allows applying multiple criteria. Formula used for the SUMIFS Function in Excel “SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, criteria_range3, criteria3, ……
What is the SUBTOTAL Function in Excel? The SUBTOTAL Functionin Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided. Formula SUBTOTAL = (method, range1, [range2 …range_n]) Where method is the type…
What is the Eisenhower Matrix? The Eisenhower Matrix – also known as the Eisenhower Decision Matrix, the Eisenhower Important/Urgent Matrix, or simply as the Important/Urgent Matrix – is a graphical tool used to prioritize tasks by ranking them on two key attributes: Importance and Urgency. The Eisenhower Matrix was derived from a quote attributed to…
What is the FORMULATEXT Function? The FORMULATEXT Function helps you get a formula in text form from the referred cell. FORMULATEXT is categorized under Excel Lookup and Reference functions. It was introduced in MS Excel 2013. Formula =FORMULATEXT(reference) Reference here is the reference to a cell or range of cells from which we want…
What is the DAYS Function? The DAYS Function in Excel is a Date/Time function that is used for calculating the number of days between two dates. The DAYS function was introduced in MS Excel 2013. Its purpose is to provide the days between two dates. Prior to this, we used End date-Start date. Formula for…
What is the Excel INDIRECT Function? The Excel INDIRECT Function returns a reference to a range. The INDIRECT function does not evaluate logical tests or conditions. Also, it will not perform calculations. Basically, this function helps lock the specified cell in a formula. Due to this, we can change a cell reference within a formula…
What is the CONCAT Function in Excel? The CONCAT Function in Excel is a text function that is used for combining text in cells. The function was introduced in MS Excel 2016 as a replacement to CONCATENATE function. However, you will find that both functions are available in MS Excel for backward compatibility. Formula =CONCAT…
What is the DECIMAL Function? The DECIMAL Function in Excel is a Math and Trigonometry function. It is used for converting a text representation of a number in a stated base into a decimal value. The function was introduced in MS Excel 2013. Formula =DECIMAL (text, radix) Where: Text is the text representation of a…
The IFNA function in Excel returns a specified value if a formula results in an #N/A error, improving data handling by replacing errors with meaningful values. Its syntax is =IFNA(value, value_if_na). It is useful for functions like VLOOKUP that may return #N/A when a value isn’t found, allowing for a cleaner, more user-friendly output. IFNA…
What is the MAXIFS Function? The MAXIFS Function in Excel is a Statistical function that returns the maximum value based on one or more than one conditions from the specified cells. The MAXIFS function was introduced in MS Excel 2019. Formula =MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) Arguments: Max_range (required argument) – The actual range…
