using countif to not count cells beginning with PLAN

J

John

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
 
Top