DSUM Workfunction

  • Thread starter Thread starter Peo Sjoblom
  • Start date Start date
P

Peo Sjoblom

DSUM will always need a criteria range, you could use sumproduct (or in
sumif in some cases) to get the same result


=SUMPRODUCT(--(Range1>1),Range2)

where Range1 would be the range where the criteria is applied on and Range2
the range where you sum
with sumif

=SUMIF(Range1,">1",Range2)
 
Hi,

does anybody know how to use DSUM Workfunction without
passing a range as a criteria. I mean, I'd like to use something
like that

=dsum(range,"quantity","number > 1")

Regards,

Marco
 
Peo,

Is your clock right ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

DSUM will always need a criteria range, you could use sumproduct (or in
sumif in some cases) to get the same result


=SUMPRODUCT(--(Range1>1),Range2)

where Range1 would be the range where the criteria is applied on and Range2
the range where you sum
with sumif

=SUMIF(Range1,">1",Range2)
 
Just wondering why your answer precedes the question in my O.E.

I guess he's the wrong one.
Brazil is on std. time, isn't it ?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

11:02 EST Jan 22 2004

Yep..
 
Back
Top