Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

    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

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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??

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •