Broken Sumproduct

[jennyaccord]

I seem to have broken sumproduct and I can't work out what the problem is.

I have a database that dumps information into Excel. Part of the information looks like this:

Please Login or Register  to view this content.

All I want to do is match the name in the first column, the word Total: in the second column and return the entry in the third column. (the columns being M, N, O)

I've entered this formula

Please Login or Register  to view this content.

but am coming up with nothing. I've adjusted the asterisks and commas, and have tried entering each one normally and as an array formula, but have come up with nothing.

I know sumproduct, I use sumproduct, but I'm tired and can't see what I'm doing wrong.

[Fotis1991]

Dif you try?

=SUMPRODUCT((Sheet1!$M$2:$M$400=A3)*(Sheet1!$N$2:$N$400="Total:")*(Sheet1!$O$2:$O$400))

[CheshireCat]

If a #VALUE! error is encountered, try this as an alternative:

Please Login or Register  to view this content.

[jennyaccord]

Thanks for the replys guys.

I have no idea what's going on with the spreadsheet. It just doesn't seem to be responding correctly. Both of the suggestions resulted in zero results, yet the information is there and, when I use the Evaluate formula option, it finds the information, but still returns zero.

I'll try it again tomorrow.

Thanks again.