Formula direction needed

[lex.luthor]

I have a simple spread sheet that I am looking for the the information to be displayed:

Date, mechanic and the total time per day.

I have tried a sum if formula and it doesnt seem to work because of the date.

I am not sure if a sum product or a sum if with a vlookup formula will work. I cannot seem to get the sum if with a vlookup to work when I enter it in. It tells me that I have too less of arguments and errors out.

I have also thought of a pivot table as well.

Could someone try to help guide me in a direction that would work?

Thank you for your help.

[Pete_UK]

Two immediate things stand out when I opened your file:

a. The "dates" that you have in cells A2:A16 are text values rather than dates that Excel recognises.

b. The ranges in your SUMIF formula in N3 should be the same, e.g.:

=SUMIF(C2:C32,"*"&M3&"*",K2:K32)

but as your data extends down to row 47, the references should be changed to cover all your data.

However, even after those changes are made I'm not really sure what you are trying to do - do you want to sum the hours by the mechanic in cell M3 which occur between the start date and end date?

Hope this helps.

Pete

[JohnTopley]

Try in O3

=SUMIFS($K$2:$K$32,$A$2:$A$32,$N$5,$C$2:$C$32,"*"&M3&"*")

[lex.luthor]

Pete,

Thank you for the quick replay. I have changed the format of the times, and yes I would like to show the mechanic time on the other page that would be for that specific date.

[lex.luthor]

I beleive that this one would work the best. I beleive that I would be able to modify it to show those results on a different page as well. Thank you all for the replies. Slainte!