Results 1 to 2 of 2
Thread: Excel Functions (Excel 2000)
2003-06-03, 16:16 #1
- Join Date
- May 2003
- 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.
2003-06-03, 16:23 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 191 Times in 177 Posts
Re: Excel Functions (Excel 2000)
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,
Microsoft MVP - Excel