Excel - Count number of cells containing a file name

M

Matty C

I need to cound the number of entries in a cell that contain a file nam
that starts with BE. All of the names in the cells start with BE an
then contain file specific information ie date and time. Was thinkin
of using CountIf but unsure how to limit the criteria so that cell
with a file name in them are counted.

e.g. =CountIF(A100:A500,"cells with text starting BE")

Thanks
 
R

Ron Rosenfeld

I need to cound the number of entries in a cell that contain a file name
that starts with BE. All of the names in the cells start with BE and
then contain file specific information ie date and time. Was thinking
of using CountIf but unsure how to limit the criteria so that cells
with a file name in them are counted.

e.g. =CountIF(A100:A500,"cells with text starting BE")

Thanks.
Click to expand...

=COUNTIF(A100:A500,"BE*")

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count cells containing specific text when adjacent cell contains datewithin a range... 4
Excel Use COUNTIF across a range of cells with formulas 0
Mutiply in a range of cells ? 1
counting empty cells in a column. 5
Using COUNTIF to count explicit text that DOES NOT include other text 8
Count the number of cells containing a date within a range 5
Count number of cells containing a specific date range 7
Count the cells if colored red 5

Top