Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM with criteria:blank OR some value
Cells in Column A, headed "date" are either blank or contain dates; cells in
column B, headed "Amount", contain a number. I want to sum, using DSUM, cells in column B, where the corresponding cell in column A is either blank or contains a date after a certain date. But however I set up the criteria table, it doesn't seem to work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM with criteria:blank OR some value
Maybe this with your criteria date in C1
=SUMIF(A2:A20,"",B2:B20)+SUMIF(A2:A20,""&C1,B2:B2 0) Mike "EricK" wrote: Cells in Column A, headed "date" are either blank or contain dates; cells in column B, headed "Amount", contain a number. I want to sum, using DSUM, cells in column B, where the corresponding cell in column A is either blank or contains a date after a certain date. But however I set up the criteria table, it doesn't seem to work. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM with criteria:blank OR some value
Hi,
Give us an example of your data layout, the criteria and the DSUM formula which are you using -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "EricK" wrote in message ... Cells in Column A, headed "date" are either blank or contain dates; cells in column B, headed "Amount", contain a number. I want to sum, using DSUM, cells in column B, where the corresponding cell in column A is either blank or contains a date after a certain date. But however I set up the criteria table, it doesn't seem to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DSUM with variable Criteria | Excel Worksheet Functions | |||
DSUM criteria | Excel Worksheet Functions | |||
DSum criteria | Excel Worksheet Functions | |||
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA | New Users to Excel | |||
Using DSUM with several criteria | Excel Worksheet Functions |