LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
becky
 
Posts: n/a
Default DATABASE FORMULA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Creating Formula using check boxes Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 08:37 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"