Kenzuggr

 We can't check for East region in one column, and then count items in a different column This short video shows an example of using the COUNTIF function, to count based on a single criterion More Criteria With COUNTIFS To count based on multiple criteria, use the COUNTIFS functionCOUNTIFS applies criteria to cells across multiple ranges, and counts the number of times all criteria are met This is the syntax of the COUNTIFS function criteria_range1 is required It's the first range that was evaluated criteria1 is required It is the criteria by which criteria_range1 is evaluated criteria_range2, criteria2, and so onThe Blog Post for this Excel tip can be found here http//wwwhowtoexcelatexcelcom/formulas/formulafridaycountifswithmultiplecriteriainexcel/****SUB How To Use Multiple Criteria In Excel Countif And Countifs Excel vba countif multiple criteria different column