Function Arguments result correct but cell shows 0?

I'm trying to do a semi-advanced SUM which checks a sheet of timesheet data and if the day matches, sums the data for that user (Date is in Cell A, Username M and number of minutes in N).

My formula is as so:

=SUM(IF(Timesheets!$A$2:$A$1000=A2,IF(C$1=Timesheets!$M$2:$M$1000,Timesheets!$N$2:$N$1000)))

What's interesting is when I check this in the function arguments checker, it shows the correct value for that user/day combination but in the cell it's showing 0.

I've checked it's not a formatting issue (it's not) and all the references are right but I can't fathom it out. Any ideas?

Thanks in advance

Tim

TMS You're a genius, that worked a treat thank you ever so much for you insanely quick reply.

I thought I could use SUMIF too but I think the criteria are too specific...

Sum if:
1. The day columns match (A)
2. The name row value matches the column header (M)
3. Sum the range N

I might be wrong though.

And yes, solved thanks, not sure I can mark this as solved, will change the title

>SUMIFS ... not SUMIF
Ah nice thanks, will check that out.

>Why can't you mark it as solved?
Because it wasn't obvious when at the bottom of the page. Have found and marked as solved thanks