| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing while suming | New Users to Excel | |||
| Muliple columns in one cell after export | Excel Discussion (Misc queries) | |||
| suming in add-ins | Excel Worksheet Functions | |||
| Convert muliple data into columns | Excel Discussion (Misc queries) | |||
| count cells across muliple columns | Excel Worksheet Functions | |||
Hybrid Mode
