Using text in one column to id values in another? (Excel XP)

[Scooter]

Please bear with me... I'm new to this. For a payroll sheet, I want to ID leave hours (sick, comp. time, vacation, etc.) in one column and enter the # of hours in the next. I then want Excel to total the # of vacation hours and # of sick hours, etc and put the sums at the bottom of the page in a table. How do I do this?

Thanks for any help!

[sdckapr]

Sounds like a job for the PivotTable or using SUMIF formulas

PivotTable has a wizard (data - Pivot table report) answer the wizard.

Sumif can do similar things but you must enter in the tems yourself.

Hope this helps,
Steve

[Dominik]

May be I did not get the complexity of your problem.
As far as I understand, you do not need to refer to the text.
Why can you not use just the SUM function of excel summing the concerned cells??

[LegareColeman]

The SUMIF function should do what you are asking. However, we can't give you the formula without seeing what your ID codes are and what the column layout looks like.