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