Excel Formula COUNTIFS With Multiple Criteria

The Blog Post for this Excel tip can be found here. http://www.howtoexcelatexcel.com/formulas/formula-friday-countifs-with-multiple-criteria-in-excel/ ****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com ****Other Places You Can Find Me For More Excel Tips*** ++Website http://www.howtoexcelatexcel.excel.com ++Twitter https://twitter.com/howtoexcelatex ++Pinterest http://www.pinterest.com/howtoexcelat Do you want become an expert in Excel?. Then take a look at Mynda Treacy's Excel Expert course. The Link is here..http://www.mothresource.com/152-8-3-11.html This video is inspiried by a question I received from Lyn in -to my email box earlier this week. The question was how to count a number of items in a list that met more than one criteria, for example how many orders of Beannie_H hats were for Size Large. The easiest way to answer these type of questions with the COUNTIFS function. COUNTIFS is available in Excel 2007 onwards. The syntax of the Formula is =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) Watch to see the solution.