Various Count Functions ... you may find it necessary to count the number of cells containing data in a worksheet. ... (range, criteria). You can use this function, for example, to count the ...

Enter the example data, as shown, into a blank Excel worksheet. Select cell F8 , which is where the function results will display. Type this into cell F8 and then press Enter : ...

If you have a mix of numbers and text in cells A21-A50, for example, type into cell A51 =COUNT(A21:50) and you’ll have the answer in no time. Melissa Riofrio/IDG ...

For example, you have a busy worksheet with a lot of data points, and you want to know the name of a supplier and the corresponding supplier’s specific phone number, VLOOKUP can come in handy.