Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |