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

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

If you have a cell named Currentmonthend that holds the criteria try it like
this:

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


--
Biff
Microsoft Excel MVP


"Henry" wrote in message
...
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

Try:

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


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

--

Dave Peterson