DSUM

[TimU]

I am trying to do a DSUM function but am having trouble
with the criteria argument. I want the criteria to
reference multiple cells in a summary section. The help
section says that a criteria range needs to be referenced
but I can't see how that would work.

Any help will be appreciated greatly.

 

[Don]

Hi Tim,

Not sure I can help much on this but I'll give it a whirl
and see what happens....we may both learn something here.

You've got your Data Range, assume C3:H24, laid out with
headers across the top(for this example title cell
D3 "Width"). Enter some various widths down Col D,
duplicating some. Enter some random dollar amounts in
H4:H24.

For this example enter the following in E25:

=DSUM(C3:H24,H3,E23:E24)

In E23..enter "Width"...that's the Col we want to search
through.
In E24..enter one of the widths you entered above.

E25 will display the total cost of the searched for info.

Sure hope this works for you.....if not, I'm sure we'll
both learn something here,

Don

 

[TimU]

Hi Don,

Thanks for the response. I'm trying to avoid the criteria
range, if possible. I need to have cell references in the
criteria. It may be impossible but that would be a shame,
because it was quite easy to do in Lotus. Following is an
example of what I am trying to do:

A1 B1 C1 D1
A2 Datatable
A3 NAME REGION AMOUNT
A4 BOB WEST 11
A5 STAN EAST 22
A6 JOE WEST 33
A7 BOB WEST 44
A8
A9
A10 Summary
A11 NAME REGION AMOUNT
A12 BOB WEST criteria: NAME=B12 and REGION=C12
A13 STAN EAST criteria: NAME=B13 and REGION=C13
A14 JOE WEST criteria: NAME=B14 and REGION=C14

I'm trying to get the DSUM formula in D1214

-Tim