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.
|