Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 13

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DSUM with variable Criteria	Michael Dam	Excel Worksheet Functions	5	December 18th 07 06:29 PM
DSUM criteria	Edward	Excel Worksheet Functions	3	July 9th 07 04:19 PM
DSum criteria	Troubled	Excel Worksheet Functions	2	November 8th 06 04:22 AM
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA	Michael H.M.Mikhail	New Users to Excel	1	May 23rd 06 09:42 AM
Using DSUM with several criteria	matthoffman33	Excel Worksheet Functions	2	May 6th 06 05:46 PM

All times are GMT +1. The time now is 08:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us