LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George Davis
 
Posts: n/a
Default DSUM with Criteria containing non-hardcoded values?

In all the help for the database functions, the criteria always show the
values hard coded with a value like:

="=10"

I want to have a sum of a certain column where the date is within 2 dates I
have derived (using formulas) in two cells outside the database and criteria
range.

For example, I have a database in A1:D10 and the criteria is in F1:H2.
Column A is a column of numbers and column B is a column of dates. I have a
begin date calculated in J2 and an end date calculated in K2. Column F
matches column A and columns G and H both match column B so that I can do
multiple criteria on column B. How do I set the values of G2 and H2 so that
it basically says:

in G2 - Date in column B is = J2
in H2 - Date in column B is also <= K2

I've tried in G2 - ="=J2"
I've tried in H2 - ="<=K2"

My DSUM looks like ("Score" is column A):
=DSUM(A1:D10,"Score",F1:H2) but I get the error:

A values in this formula is of the wrong data type

I looked at the help for that error but I don't see what I'm doing wrong.
It doesn't seem like Excel will allow a cell reference in the Criteria
section. All the help examples are hard coded. How do I get a criteria to
refer to a cell's value instead of hard coding the criteria values?

Thanks,
George
 
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
Keeping a cell value constant trhoughout a list of values borikua05 Excel Worksheet Functions 2 December 3rd 05 03:03 PM
Combine FREQUENCY and SUM of Associated Values MichaelC Excel Worksheet Functions 3 July 3rd 05 01:54 AM
DSUM and DCount when criteria values are similar BAC Excel Worksheet Functions 1 February 14th 05 06:38 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM


All times are GMT +1. The time now is 01:30 PM.

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"