Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a formula that I created in a worksheet that reads thus
=DSUM(DB,3,JAN) The database is a range of cells from A6 to G36, the 3 represents the third column in the database (or the field) and the JAN is the Criteria on another sheet. These cells are C3 which equals the word DATE and C4 which has the following formula =AND('Expense 1'!A7=Criteria!$A$4, 'Expense 1'!A7<=Criteria!$B$4) Everytime I try to Copy the Sheet Expenses 1 the formula does not work. I get all zeros where the =DSUM formula should be calculating. Does anyone know how I can get these formulas to work when I Copy the Sheet and create a new one? I need 25 Sheets that will all do the same math. Thanks -- bb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |