| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count cells beginning with specific letter? | New Users to Excel | |||
| COUNTIF to count cells that have an attached comment | Excel Discussion (Misc queries) | |||
| Can one count cells having a certain format? i.e. using countif? | Excel Worksheet Functions | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
| In COUNTIF function, how do I count the number of cells which con. | Excel Worksheet Functions | |||
Linear Mode
