My wild guess is that you typed the £ symbol instead of formatting the cells.
Try with no currency - use pure numerical values.
In addition keep your BOTH criterion free of leading/tailing spaces
Micky


"Natalie" wrote:

I can't get this to work as it keeps returned 0.00 which is incorrect.

"Teethless mama" wrote:

Take a look SUMIF() in help menu


"Natalie" wrote:

Hi, Please help!

I have a database -

ColumnA Column B
OVERDUE £100
OVERDUE £50
NOT DUE £50
OVERDUE £50
NOT DUE £125

And i want to return

OVERDUE £200
NOTDUE £175

But I can't do it. I think I need DSUM? But I'm not sure.

Please help