Problem with criteria for DSUM (Excel XP)

  • Thread starter Thread starter Mike Webb
  • Start date Start date
M

Mike Webb

I'm having a problem with the criteria for a DSUM formual on a worksheet;
the workbook is a budget worksheet I got from a large non-profit that I'm
learnign and (hopefully) going to adapt for our use.
The worksheet in question is named Cash Budget. One of the expense items is
named "Conf./Training/Meeting". The column names come from another sheet
called "Chart of Accounts" and are labeled "Jan -07", Feb-07", etc. Hiden
above each is the rest of the criteria; cell 1 has the word "Timing" and
cell 2 has the word "monthly". The formula is:

=DSUM(Conservation,'Conservation
Projects'!$O$3,B1:B3)+DSUM(Research,'Research
Projects'!$L$3,B1:B3)+DSUM(Outreach,'Outreach
Projects'!$L$3,B1:B3)+DSUM(Development,'Development
Projects'!$L$3,B1:B3)+DSUM(Administration,'Administration
Projects'!$O$3,B1:B3)+DSUM(Capital,'Capital Projects'!$L$3,B1:B3)

The error I get is "#VALUE!" (without the qoutes). When I do a trace error,
the problem is with the "DSUM(Research,'Research Projects'!$L$3,B1:B3)" part
of the formula. I rechecked the database name, the field name, the cell,
and the criteria - even redid each and than saved the file - same results.
I then made it simple - I deleted all but the problem portion - got the same
error and it points to "B1:B3: every time. I then changed it to other
databases and fields - the formula works fine.

I can't figure out how or why this is not working. Any ideas our there? (My
experience level is between Novice and Intermediate.)
 
If you copy the headings from cells L3 and B1 to the related column
heading cells in the Research table, do you still get the error?
 
(Sorry for the delay in answering, our ISP was down.) No change when I do
as suggested.

Mike
 
Back
Top