Katameihh

 The COUNTIF function only has 2 arguments you select a range to check, and the criterion to look for So, the best that we can do with COUNTIF is to get a count of East region orders =COUNTIF(B2B11, G5) More Criteria With COUNTIFS Fortunately, there is a COUNTIFS function, and we can use it to get a count based on multiple criteriaNormally, we can quickly and easily count records between two dates, but, sometimes, you may need to countif between two dates with matching criteria E2, are the criteria you want to count based on, A1A15 is the column cells that you want to count, B2B15 is theThe formula can also work with countif function But if you want to have multiple conditions then use COUNTIFS function Related Articles Get the COUNTIFS with Two Criteria Match in Excel Get the COUNTIFS With OR function for Multiple Criteria in Excel Related Article Creative Column Chart that Includes Totals Create Overlay Chart in Excel 16 Countif Master This Amazing Formula Guide Earn Excel How to us...