And just to add,

all the "d" functions require you to use a separte set of cells to hold the
criteria. You can't put the criteria in the dsum argument list itself

--
Regards,
Tom Ogilvy


"jb" wrote:

Hello,
I need to do a dsum with a criteria of Isnumber(Check Number Column). I do
not know how to put a criteria in where I can return values only for those
rows where there is a number in another column.

Paid Check #
$100 1234
$200 Bounce
$300 4567
$400
$500 7777

I need a dsum to come back with $900 which are the 3 numeric looking Check
#'s. I can't figure out how to put the criteria in.

Thank you.