SUMIF and Named ranges
 

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

SUMIF and Named ranges
 

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

SUMIF and Named ranges
 

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

SUMIF and Named ranges
 

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