feltcherandrew
New Member
- Joined
- Oct 18, 2011
- Messages
- 2
Hi -
I was wondering if there is a way to make DSUM work with using multiple criteria possibly including an indirect cell reference. What I'm trying to accomplish is something like this:
=DSUM('database',field,A3&L2:L4)
I would like A2 to change as I copy the field down the column, the L2:L4 follow the normal usage pattern in the DSUM formula.
Is this possible? I've looked at the INDIRECT function but that doesn't seem to help.
Many thanks!
Andrew
I was wondering if there is a way to make DSUM work with using multiple criteria possibly including an indirect cell reference. What I'm trying to accomplish is something like this:
=DSUM('database',field,A3&L2:L4)
I would like A2 to change as I copy the field down the column, the L2:L4 follow the normal usage pattern in the DSUM formula.
Is this possible? I've looked at the INDIRECT function but that doesn't seem to help.
Many thanks!
Andrew