Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by …
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Sum values based on multiple conditions - Microsoft Support
Sum values based on one or more conditions by using the SUMIFS function in a formula.
COUNTIFS function - Microsoft Support
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
SUMIFS function - Microsoft Support
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.
Use the COUNTIF function in Microsoft Excel
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
SUMIF function - Microsoft Support
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Filter by using advanced criteria - Microsoft Support
To find rows that meet multiple criteria in multiple columns where any criteria can be true, type the criteria in the different columns and rows of the criteria range.