Help with suming muliple columns

[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

 

[Teethless mama]

Take a look SUMIF() in help menu

 

[Natalie]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[Brad Autry]

Did you put your text in quotes?

like this

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

and

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

 

[Ashish Mathur]

Hi,

You may create a pivot table. Drag column A to the row area and column B to
the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com