David H Ringstrom continues his exploration of Excel functions with an explanation of how COUNTIF can work with LARGE and SMALL functions to manage numerical lists. My last tutorial demonstrated how ...

Other Excel tutorials and resources Overall, the COUNTIF () function is fairly simple to use — it’s the condition expressed in criteria that might cause confusion.

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions.

If you want to know how to use VLOOKUP with COUNTIF, we’ve got you covered. In this guide, we will discuss how to combine two essential functions in Excel – VLOOKUP and COUNTIF. VLOOKUP helps find ...

Excel logical formulas: 12 simple IF statements to get started Learn the ins and outs of the logical formulas like the famous IF Statements that represent the heart of Excel.