To do this, you'll need to use the COUNTIF function. However ... you can confidently say you know what the hash sign does in Microsoft Excel formulas!

Excel for the web fully supports COUNTIF(). To follow along with our specific examples, you can download the demonstration file here. Jump to: Can the COUNTIF function reference a cell? How do I ...

The raw data you enter into Microsoft Excel fuels your calculations and projections for sales, staffing, client acquisition and business productivity. To find the patterns and trends within that ...

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.

Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to ...

So for example: A B C 1 joebloggs JOEBLOGGS 5 2 joebloggs 3 joebloggs 4 joebloggs 5 joebloggs These names will vary so you cannot specify the names using COUNTIF function. You need Excel to populate ...