We’ve previously established the rules for writing criteria in the SUMIFS function: we can reference any cell we can enter any number directly into the function we can enter text directly in the function, nested inside quotation marks “” a logical test is nested inside of quotation marks “”, with the comparison operator coming first and a number second. We will further expand on the topic in this article. Formulas and functions can also be nested in SUMIFS criteria. If needed, …
Category: Excel Functions
Combining SUMIFS with INDEX MATCH
Using the SUMIFS function, we can sum all of the values in a defined column (or row) that meet one or more criteria. When SUMIFS is combined with INDEX MATCH, that sum range doesn’t have to be defined anymore; it is now rather specified in the function arguments. By combining SUMIFS with INDEX MATCH, we can then sum all of the values that meet multiple criteria in different rows and columns and do this in a simple way, avoiding complex and …
Combine EOMONTH with SEQUENCE: generate a sequence of dates
You will sometimes need to generate a sequence of dates in Excel. Most often, you will need month-end dates, but no matter what kind of dates you need, the simplest way to generate them will include the EOMONTH function combined with the SEQUENCE function. The EOMONTH function returns the last day of the month in relation to the start date. The EOMONTH function syntax is as follows: = EOMONTH ( start_date; number of months ) The start date is …