Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Functions (Excel 2000)

    In attempting to insert another function, I've run into a problem. I have several columns of related information with 300+ rows. What I'm trying to accomplish is this. I have several different people and several different applications of which both can be repeated throughout the worksheet - but they are different in the respect to hours worked.

    What I'm trying to accomplish is if I take one person (Melinda) and one application (AirMax) and total those hours for her only. This application appears throughout the worksheet but I'm only trying total one person per application. So if you have two completely different criteria (person & application) how do you get a function to distinguish between everything else?

    I'm attaching a workbook so that you can see what data I'm working with.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Functions (Excel 2000)

    Hi,
    I don't know if this is exactly what you're after but a pivot table seems the simplest thing for this, as in the attached workbook.
    If you only want it for one specific combination, you could use array formulae or filters and the Subtotal function.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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