Excel - Count number of cells containing a file name

  • Thread starter Thread starter Matty C
  • Start date Start date
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
 
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
 
Back
Top