DSUM between criteria

[andym]

Dear All,

I have no problems successfully creating a DSUN function if the criteria is
a single value...

ie.. 20.30 or >=15.50, etc..

eg .. =DSUM(Range,2,A1:A2), where A1 = "Price", and A2 = ">=15.50"

However, how can I complete a DSUM function if ,for example, I needed to sum
values that match "Between 10 and 20 incl"??

eg .. =DSUM(Range,2,A1:A2), where A1 = "Price", and A2 = "Between 10 and
20 incl"

Any help would be appreciated.....

Regards,

andy

 

[Peo Sjoblom]

You would need 4 cells for the criteria
assume you would use A1:B2 as criteria then those cells would look like

Price Price

10 <20

or use same cell criteria and a formula, leave A1 blank and in A2 put

=AND(B4>10,B4<20)

where B4 is the first cell with data in the 2nd column (first after header)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Debra Dalgleish]

I think Peo meant to use >= and <= operators, e.g.

Price Price

=10 <=20

=AND(B4>=10,B4<=20)

 

[andym]

easy stuff!!!

Thanks very much Peo and Debra ... easier than I thought..

Regards,

andy...