using countif to not count cells beginning with PLAN
 

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

using countif to not count cells beginning with PLAN
 

Your formula works ok here. Maybe try it again?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"John" wrote:
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