Help with suming muliple columns
 

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

Help with suming muliple columns
 

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

Help with suming muliple columns
 

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

Help with suming muliple columns
 

Did you put your text in quotes?

like this

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

and

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



"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

Help with suming muliple columns
 

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

Help with suming muliple columns
 

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

"Natalie" wrote in message
...
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