DSUM Workfunction

[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)

 

[Marco Roberto]

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

 

[RagDyer]

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)

 

[Peo Sjoblom]

11:02 EST Jan 22 2004

Yep..

 

[RagDyer]

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