I got a #Ref error with that.

Basically I'm trying to count the number of projects per division per phase.
But my list of projects is divided into division/subdivision and phase.

Example data in the cells would be:

Project Phase Division

Project1 Proposed AppDev
Project2 Initiation AppDev.DBA
Project3 Execution Communications.Radio
Project4 Proposed Communications.Radio

So what I want is a count of AppDev projects by phase and comm projects by
phase. But just putting communications doesn't give me all comm projects.
So I need basically a wildcard character (or something that will roll all
comm.* projects up.
Thanks


"Frank Kabel" wrote in message
...
Hi
try:
=SUMPRODUCT(('Project
Portfolio'!S3:S214="Proposed")*(ISNUMBER(SEARCH("A ppDev",'Project
Portfolio'!T3:T214))))

--
Regards
Frank Kabel
Frankfurt, Germany

"John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us schrieb im
Newsbeitrag ...
Similar: =SUMPRODUCT(('Project
Portfolio'!S3:S214="Proposed")*('Project
Portfolio'!T3:T214="AppDev"))

Where it shows AppDev, I want to to basically be AppDev.* but it
doesn't
seem to work. Any ideas?

"Frank Kabel" wrote in message
...
Hi
do you mean
=COUNTIF(A1:A100,"AppDev.*")

--
Regards
Frank Kabel
Frankfurt, Germany

"John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us schrieb im
Newsbeitrag ...
Is there a wildcard character in Excel?

Specifically, I'm looking to search for all subdivisions from a
major
division. My naming scheme is like this:

AppDev.DBA
AppDev.Web
Communications.Data
Communications.Radio

How can I just say AppDev.* or Communications.* so I can get a
full
count??? (PS there is no standard length to any of these names)

Thanks