Using Excel 2007.
I want to create a series of cells with a formula that will count the 
number of cells elsewhere that contain a certain word.
"[ ]" means a cell.

Example:
[Category 1]
    [sub category 2] [#of instances]
    [sub category 3] [#of instances]

Elsewhere on that XL spread sheet, I would have rows that have
    [sub category 2] [data...] [data...]
    [sub category 2] [data..] [data..]
    [sub category 2] [data....] [data....]

    [sub category 3] [data] [data]
    [sub category 3] [data] [data]
    [sub category 3] [data] [data]
    [sub category 3] [data] [data]
	etc.

What I want to do is have the first ("summary group") to show
[Category 1]
    [sub category 2] [3]
    [sub category 3] [4]
	etc.

How would I do that?

Thanks.

Have you tried the COUNTIF function?

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
<Jeff@nospam.fake> wrote in message 
news:eYIY$f0$KHA.5848@TK2MSFTNGP06.phx.gbl...
> Using Excel 2007.
> I want to create a series of cells with a formula that will count the 
> number of cells elsewhere that contain a certain word.
> "[ ]" means a cell.
>
> Example:
> [Category 1]
>    [sub category 2] [#of instances]
>    [sub category 3] [#of instances]
>
> Elsewhere on that XL spread sheet, I would have rows that have
>    [sub category 2] [data...] [data...]
>    [sub category 2] [data..] [data..]
>    [sub category 2] [data....] [data....]
>
>    [sub category 3] [data] [data]
>    [sub category 3] [data] [data]
>    [sub category 3] [data] [data]
>    [sub category 3] [data] [data]
> etc.
>
> What I want to do is have the first ("summary group") to show
> [Category 1]
>    [sub category 2] [3]
>    [sub category 3] [4]
> etc.
>
> How would I do that?
>
> Thanks. 

On 5/29/2010 1:07 PM, Don Guillett wrote:
> Have you tried the COUNTIF function?
>
No, because I'm a complete newbie at Excel formulas.  Will that do it? I 
will try to learn about it.

Thanks.

Look in the help index for COUNTIF

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
<Jeff@nospam.fake> wrote in message 
news:ObwRTV1$KHA.3580@TK2MSFTNGP06.phx.gbl...
> On 5/29/2010 1:07 PM, Don Guillett wrote:
>> Have you tried the COUNTIF function?
>>
> No, because I'm a complete newbie at Excel formulas.  Will that do it? I 
> will try to learn about it.
>
> Thanks.