Help with suming muliple columns

  • Thread starter Thread starter Natalie
  • Start date Start date
N

Natalie

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
 
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
 
Did you put your text in quotes?

like this

=SUMIF(A1:B5,"OVERDUE",B1:B5)

and

=SUMIF(A1:B5,"NOT DUE",B1:B5)
 
Back
Top