Function Arguments result correct but cell shows 0?

**timgaunt** · 06-19-2012, 01:53 AM

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:

Please Login or Register  to view this content.

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** · 06-19-2012, 01:56 AM

That's an array function and needs to be committed with Ctrl-Shift-Enter rather than just Enter.

Regards, TMS

**timgaunt** · 06-19-2012, 01:57 AM

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

**TMS** · 06-19-2012, 01:58 AM

With 2010, you should be able to use SUMIFS.

Regards, TMS

**TMS** · 06-19-2012, 02:06 AM

You're welcome.

Solved?

Regards, TMS

**timgaunt** · 06-19-2012, 02:11 AM

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

**TMS** · 06-19-2012, 02:12 AM

SUMIFS ... not SUMIF.

**TMS** · 06-19-2012, 02:13 AM

Why can't you mark it as solved?

**timgaunt** · 06-19-2012, 02:17 AM

>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