I think Ron is right and you might find that Pivot Tables are easier than you
think.....
Try this:

Select your data range
DataPivot TableSource: Excel List...Click Next
Range: (already selected)...Click Next

Click the [Layout] button
ROW: Drag the Name field here (Dbl-click it and set subtotals to None)

COLUMN: Drag the Type field here

DATA: Drag the Days field here
(If it doesn't change to Sum of Days: Dbl-click it and set SUM)

Click [OK]
Select a destination then click [Finish

That's all you need to do to get the kind of table you described.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"ims" wrote:

Thanks Ron, if possible, i prefer using formula rather than pivot table,
which seems much more complicated.

Turks


"Ron Rosenfeld" ¼¶¼g©ó¶l¥ó·s»D
...
On Wed, 28 Dec 2005 11:13:33 +0800, "ims" wrote:

Dear all,

I have a worksheet

A B C
Days Name Type
5 Kent Computer
0.5 Kent Safety
3 Susan Computer
2 Peter Management
1 Peter Safety

I want to consolidate the data above into the following table

A B C D
Name Computer Safety Management
Kent 5 0.5 0
Susan 3 0 0
Peter 0 1 2

What should the formula use in the table?

Thanks
Turk


You could use a Pivot Table and generate that summary in no time.
--ron