Hi,

I can do this in two steps using but i'm wanting to be a little more clever.

In a range i have a list of filenames. I want to exclude in the count all
filenames that begin with PLAN. I've tried using Countif(A2:A550,"<PLAN*")
but it's not working!! Any ideas how i could do this please?

Thanks
John