Take the name out of the quoted string. E.g,

=SUMIF(Dates,"<="&CurrentMonthEnd)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 20 May 2009 13:32:01 -0700, Henry
wrote:

How can I get this formula to work. The idea is to create a dynamic formula
where the it sums a range based on the date as it changes each month. e.g.

=SUMIF(Dates,"<=Currentmonthend",revenue)
=SUMIFS(revenue,Dates,"<=Currentmonthend")

neither works, it will work if I substituted a proper date such as
03/31/2009 for currentmonthend, whenever greater than or less than sign is
involved it does not work. Any ideas? Thanks.

Henry