Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with criteria for DSUM (Excel XP)
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,'Developmen t Projects'!$L$3,B1:B3)+DSUM(Administration,'Adminis tration 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.) -- Mike Webb Platte River Whooping Crane Maintenance Trust, Inc. a 501 (c)(3) conservation non-profit organization |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with criteria for DSUM (Excel XP)
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? Mike Webb wrote: 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,'Developmen t Projects'!$L$3,B1:B3)+DSUM(Administration,'Adminis tration 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.) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem with criteria for DSUM (Excel XP)
(Sorry for the delay in answering, our ISP was down.) No change when I do
as suggested. Mike "Debra Dalgleish" wrote in message ... 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? Mike Webb wrote: 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,'Developmen t Projects'!$L$3,B1:B3)+DSUM(Administration,'Adminis tration 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.) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel 2007 Beta Setup Problem | Setting up and Configuration of Excel | |||
Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |