IF + AND“IF + AND” formulas are used to test if a value meets multiple criteria, giving one result, otherwise giving another.
COUNTIFSLearn how to COUNT the number of cells that meet multiple criteria using the COUNTIFS formula.