Excel 2003 Formula Question...

[IT-Guy]

OK... I've done researched best I could.. and cannot seem to find how to pull data from my worksheet using a conditional formula.  I have several columns of data in which one of them contains time in the format HH:MM:SS.  These times are sorted by end user extension and I wish to add them up for each user.  Does anyone have any ideas?  Here is what I was trying: =IF(VLOOKUP(5374,Sheet1!D:F,1,3),SUM(Sheet1!F:F),"No Time")... and well.. that doesn't work.   :-/

Any suggestions would be much appreciated.

Thanks.
AV.

[soybean]

What about taking different approach?  I created a simple data set for testing:
name      time
dave      11:23:33
dave      10:12:17
dale      9:57:00
dale      11:09:22
Dean      10:45:22
Dean      9:37:45

Then, I used Data, Subtotals to get:
name      time
dave      11:23:33
dave      10:12:17
dave Total      21:35:50
dale      9:57:00
dale      11:09:22
dale Total      21:06:22
Dean      10:45:22
Dean      9:37:45
Dean Total      20:23:07
Grand Total      15:05:19

[IT-Guy]

Thank you for the suggestion.  I was trapped into keeping the setup I had due to the formulas already in place for other queries... but I was able to find the answer on MR. Excel's website... (a very good place to go for excel questions!)

the answer was: =SUM(SUMIF(Sheet1!D:F,"####",Sheet1!F:F),SUMIF(Sheet1!D:F,"####",Sheet1!F:F))

Thanks again.

[soybean]

Thanks for the feedback.  Glad you mentioned mrexcel.com.  Looks like an excellent resource on Excel.