View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Concatenating Criteria in DSUM

Another way

=TEXT(A1,"MMYYYY")="012009"

If this post helps click Yes
---------------
Jacob Skaria


"Michael Conroy" wrote:

When setting up the criteria range for a DSum function, I have to use two
columns to get a date range. Does anyone know if there is a trick to
concatenating the two dates into one criteria string as demonstrated below?

Date Date
12/31/2008 <2/1/2009 for all of January but using two columns


What I am looking for is:
Date
12/31/2008 and <2/1/2009 didn't work
12/31/2008<2/1/2009 didn't work

and(12/31/2008,<2/1/2009) didn't work

The month and day are hard coded, but the year changes based on the date in
one cell of the criteria worksheet. This way I can change the year quickly.

--
Michael Conroy
Stamford, CT