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

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.Thanks for the feedback. Glad you mentioned mrexcel.com. Looks like an excellent resource on Excel.