Prom with the DSUM function

O

oteixeira

Hello
I'm having a problem with the DSUM function. As everybody knows
parameters for this function are DSUM(database, field, criteria).
have no problems with "field" and "criteria". My worksheet has a lot o
defined names ranges (which i stored in cells) and i wanted to use the
to replace the "database" parameter each time i choose a differen
department from a list. For example i have range B6:F96 named a
"area_1". If i write the formula using =DSUM(area1, field, criteria)
it works fine. However, if a store the name "area_1" into cell A1 an
change the formula to =DSUM(A1, field, criteria) i get #VALUE. Th
parameter criteria must be a cell with the name of the database colum
and at lest one cell above with the filter to be applied. For thes
parameter i can use a named range. Will it be possible that i canno
use this technique for the database parameter?
Any help would be very much appreciated
 
M

Marcelo

Hi Teixeira,

try to use an indirect function as:

DSUM(INDIRECT(A1),FIELD,CRITERIA)

Hope this helps
Regards from Brazil
Marcelo

"oteixeira" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum and Dmax with structured references 1
Dsum formula interpretation 2
Criteria field in dsum formula 2
Dsum with multiple Criteria not working 0
Excel - Wich Function should I use? 1
Summing a range of cells with criteria 7
Old DSUM formula not working in Excel 2007 0
Excel 2007: =DSUM not working as expected 4

Top