hi,
i have to columns date and name (ex : Andy - 03/01/79)
i would like to count all Andy's cells of every monthe (january=3,february=2
....)

How can I do it ?

Make sure you have headers, then select the table and do data>pivot table
and pivotchart report. Click next twice and select layout, drag names and
dates into the row field and drag names into the data field as well, right
click any of the cells with a date in the pivot table and select group, then
group by month



--
Regards,

Peo Sjoblom



"hasdou" <(E-Mail Removed)> wrote in message
news29D1F40-F635-4080-859B-(E-Mail Removed)...
> hi,
> i have to columns date and name (ex : Andy - 03/01/79)
> i would like to count all Andy's cells of every monthe
> (january=3,february=2
> ...)
>
> How can I do it ?
>

Since you have months you want to group you would probably get a better
looking table if you put the time header in the column field



--
Regards,

Peo Sjoblom




"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Make sure you have headers, then select the table and do data>pivot table
> and pivotchart report. Click next twice and select layout, drag names and
> dates into the row field and drag names into the data field as well, right
> click any of the cells with a date in the pivot table and select group,
> then group by month
>
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "hasdou" <(E-Mail Removed)> wrote in message
> news29D1F40-F635-4080-859B-(E-Mail Removed)...
>> hi,
>> i have to columns date and name (ex : Andy - 03/01/79)
>> i would like to count all Andy's cells of every monthe
>> (january=3,february=2
>> ...)
>>
>> How can I do it ?
>>
>
>